ADO Tips & Tricks1) Connection Objecta)
Opening the Database
b)
Executing Commands
c)
Executing Queries
d)
Closing the Database
2) Recordset Objecta)
The Fields Collection
b)
Editing Records
3) Toolsa)
One Column Queries
b)
ComboBox Example
c)
One Row Queries
d)
Multi-Column Queries
e)
Getting Field Names
f)
ComboBox Example, 2
4) A Useful Examplea)
The SELECT Clause
b)
The WHERE Clause
c)
The Query
|
A
Useful Example
A
query statement returns a Recordset that you can use to view the data
selected.
FieldNames is initialize
using GetQueryFields. SelectedFields is initially True for all fields. ' A list of the available
fields.
Public FieldNames As Collection
' True for selected fields.
False for the others.
Public SelectedFields As Collection
|
