|
DaoQuery:Init() Method |
  
|
|
DaoQuery:Init() Method |
|
Purpose
Create a new object of type DaoQuery
Parameters
| uQuery | String that holds the tablename, querydefname or a valid SQL select string, or a DaoRecordSet object |
| nType | (Optional) RecordSettype. See DaoDatabase:OpenRecordSet() for more info on these types. The value DbOpentable is NOT allowed ! |
| nOptions | (Optional) Options See DaoDatabase:OpenRecordSet() for more info on these types |
| oDb | (Optional) database object that is used to open the server. By default the DaoCurrentDb() is used |
| lUsePropsForHl | (Optional) Use Field caption & description properties for fieldSpecs & hyperlabels. |
Description
The Init method will open a new recordset (unless you pass it a recordset yourself, in which case it will use that recordset). It will store a reference to this recordset, that you can get to through the RecordSet Access.
The next step is that it will read information about all the fields in the recordset and create DataFields and FieldSpecs for each field, based on the information in this fields.
Finally it will move the recordset to the first record.
Class
See Also