DAO Topics
<<Back
Next>>

QueryDefs Object

A QueryDefs collection contains all QueryDef objects of a Database object in a Microsoft Jet database, and all QueryDef objects of a Connection object in an OBDCDirect workspace. The QueryDefs object has one property, Count, which returns the number of objects in a collection.


QueryDefs Object Methods
Method Description
Append() Adds a new DAO object to a collection.
Delete() Deletes a persistent object from a collection.
Refresh() Updates the objects in a collection to reflect the current database's schema.



QueryDef Object

A QueryDef object is a stored definition of a query in a Microsoft Jet database, or a temporary definition of a query in an ODBCDirect workspace.


QueryDef Object Properties
Property Description
Connect Sets or returns a value that provides information about the source of an open connection, an open database, a database used in a pass-through query, or a linked table. For Database objects, new Connection objects, linked tables, and TableDef object not yet appended to a collection, this property setting is read/write.
CacheSize Sets or returns the number of records retrieved from an ODBC data source that will be cached locally.
DateCreated Returns the date and time that an object was created, or the date and time a base table was created if the object is a table-type Recordset object.
LastUpdated Returns the date and time of the most recent change made to an object, or to a base table if the object is a table-type Recordset object.
LogMessages Sets or returns a value that specifies whether the messages returned from a Microsoft Jet-connected ODBC data source are recorded.
Name Sets or returns a user-defined name for a DAO object. For an object not appended to a collection, this property is read/write.
ReturnsRecords Sets or returns a value that indicates whether an SQL pass-through query to an external database returns records.
ODBCTimeout Indicates the number of seconds to wait before a timeout error occurs when a QueryDef is executed on an ODBC database.
RecordsAffected Returns the number of records affected by the most recently invoked Execute() method.
SQL Sets or returns the SQL that returns the query executed by the QueryDef object.
Updatable Returns a value that indcates whether you can change a DAO object.
Type Sets or returns a value that indicates the operational type or data type of an object.
Replicable Sets or returns a value that determines whether a database or object in a database can be replicated.
KeepLocal Sets or returns a value on a table, query, form, report, macro, or module that you don't want to replicate when the database is replicated.
Prepare Sets or returns a value that indicates whether the query should be prepared on the server as a temporary stored procedure, using the ODBC SQLPrepare API function, prior to execution.
StillExecuting Indicates whether an asynchronous operation (that is, a method called with the dbRunAsync option) has finished executing.
MaxRecords Sets or returns the maximum number of records to return from a query against an ODBC data source.



QueryDef Object Methods
Method Description
Close() Closes an open DAO object.
CreateProperty() Create a new user-defined Property object.
Execute() Runs an action query or executes an SQL statement on a specified Connection.
OpenRecordset() Creates a new Recordset object and appends it to the Recordsets collection.
Cancel() Cancels execution of a pending asynchronous method call.



Recordsets Object

A Recordsets collection contains all open Recordset objects in a Connection or Database object. The Recordsets object has one property, Count, which returns the number of objects in a collection. The Recordsets object has one method, Refresh(), whose syntax is Refresh, with no parameters. This method updates the objects in a collection to reflect the current database's schema.


Recordset Object

A Recordset object represents the records in a base table or the records that result from running a query.


Recordset Object Properties
Property Description
AbsolutePosition Sets or return the relative record number of a Recordset object's current record.
BOF Returns a value that indicates whether the current record position is before the first record in a Recordset object.
EOF Returns a value that indicates whether the current record position is after the last record in a Recordset object.
CacheSize Sets or returns the number of records retrieved from an ODBC data source that will be cached locally.
Bookmark Sets or returns a bookmark that uniquely identifies the current record in a Recordset object.
Bookmarkable Returns a value that indicates whether a Recordset object supports bookmarks, which you can set by using the Bookmark property.
EditMode Returns a value that indicates the state of editing for the current record.
Filter Sets or returns a value that determines the records included in a subsequently opened Recordset object.
Indes Sets or returns a value that indicates the name of the current Index object in a table-type Recordset object.
DateCreated Returns the date and time that an object was created, or the date and time that a base table was created if the object is a table-type Recordset object.
LastUpdated Returns the date and time of the most recent change made to an object, or to a base table if the object is a table-type Recordset object.
Restartable Returns a value that indicates whether a Recordset object supports the Requery() method, which re-executes the query on which the Recordset object is based.
PercentPosition Sets or returns a value indicating the approximate location of the current record in the Recordset object, based on a percentage of the records in the Recordset.
Name Sets or return a user-defined name for a DAO object. For an object not appended to a collection, this property is read/write.
LockEdits Sets or returns a value indicating the locking that is in effect while editing.
LastModified Returns a bookmark indicating the most recently added or changed record.
RecordCount Returns the number of records accessed in a Recordset object, or the total number of records in a table-type Recordset.
NoMatch Indicates whether a particular record was found by using the Seek method or one of the Find() methods.
Sort Sets or returns the sort order for records in a Recordset object.
Updatable Returns a value that indicates whether you can change a DAO object.
Type Sets or returns a value that indicates the operational type or data type of an object.
Transactions Returns a value that indicates whether an object supports transactions.
ValidateText Sets or returns a value that specifies the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting.
ValidationRule Sets or returns a value that validates the data in a feild as it's changed or added to a table.
UpdateOptions Sets or returns a value that indicates how the Where clause is constructed for each record during a batch update, and whether the batch update should use an Update statement or a Delete followed by an Insert.
Connection Returns the connection object that owns the Recordset.
CacheStart Sets or returns a value that specifies the bookmark of the first record in a Dynaset-type Recordset object containing data to be locally cached from an ODBC data source.
BatchCollisionCount Returns the number of records that did not complete the last batch update.
RecordStatus Returns a value indicating the update status of the current record, if it is part of a batch update.
StillExecuting Indicates whether an asynchronous operation has finished executing.
BatchSize Sets or returns the number of statements sent back to the server in each batch.
BatchCollisionRows Returns an array of bookmarks indicating the rows that generated collision in the last batch-update operation.



Recordset Object Methods
Method Description
Clone() Creates a duplicate Recordset object that refers to the original Recordset object.
Close() The object placeholder is an object variable that represents an open Connection, Database, Recordset, or Workspace object.
CopyQueryDef() Returns a QueryDef object that is a copy of the QueryDef used to create the Recordset object represented by the recordset placeholder.
AddNew() Creates a new record for an updatable Recordset object.
CancelUpdate() Cancels any pending updates for a Recordset object.
Edit() Copies the current record from an updatable Recordset object to the copy buffer for subsequent editing.
FillCache() Fills all the part of a local cache for a Recordset object that contains data from a Microsoft Jet-connected ODBC data source.
Delete() Deletes the current record in an updatable Recordset object. For ODBCDirect workspaces, the type of driver determines whether Recordset objects are updatable, and therefore support the Delete() method.
FindFirst() Locates the first record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and then makes that record the current record.
FindLast() Locates the last record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and then makes that record the current record.
FindNext() Locates the next record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and then makes that record the current record.
FindPrevious() Locates the previous record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and then makes that record the current record.
MoveFirst() Move to the first record in a specified Recordset object and make that record the current record.
MoveLast() Move to the last record in a specified Recordset object and make that record the current record.
MoveNext() Move to the next record in a specified Recordset object and make that record the current record.
MovePrevious() Move to the previous record in a specified Recordset object and make that record the current record.
GetRows() Retrieves multiple rows from a Recordset object.
Move() Move the position of the current record in a Recordset object.
Seek() Locates the record in an indexed table-type Recordset object that satisfies the specified criteria for the current index and then makes that record for the current record.
OpenRecordset() Creates a new Recordset object and appends it to the Recordsets collection.
Update() Updates the data in a Recordset object by re-executing the query on which the object is based.
Requery() Updates the data in a Recordset object by re-executing the query on which the object is based.
Cancel() Cancels execution of a pending asynchronous method call.
NextRecordset() Gets the next set of records, if any, returned by a multipart select query in an OpenRecordset call, and returns a Boolean value indicating whether one or more additional records are pending.





<<Back
top
Next>>





Copyright� 2000 by Noel