Database Commands SECTION 6 Functions and Methods
112
Typical Examples
State = DBState("Invoice", "Closed")
Checks if the Connection "Invoice" is currently closed.
State = DBState("Northwind.Customers", "Open")
Checks if the Recordset "Customers" is currently open.
6-17-12 DBSupports
Description
Returns TRUE if the specified Recordset supports the requested operation.
Syntax
return = DBSupports(level, operation)
Remarks
Typical Example
Result = DBSupports("CSV.Recordset1", "Delete")
Checks if records can be deleted in 'Recordset1'
6-17-13 DBUpdate
Description
Update the record being added in a Recordset. Used in conjunction with
DBAddNew to commit a new record.
Syntax
returnstate = DBUpdate(level)
level text A text point or constant specifying the
connection level. This may be a Connection or
Recordset level.
state text The requested state must be either "Open" or
"Closed"
Argument Type Description
Argument Type Description
return bool 1 if the specified level is in the requested state,
otherwise 0
level text A text point or constant specifying the
connection level. This may be a Connection or
Recordset level.
operation text The requested operation may be one of:
"AddNew"
"Bookmark"
"Delete"
"Find"
"MovePrevious"
"Update"
Note: If the "MovePrevious" operation is not supported then only 'Forward-Only'
cursor movements are supported.
Note: DBUpdate is ONLY required when DBAddNew has been used at the Field
level. When DBAddNew is used at the Recordset level an additional DBUpdate
is not required as this is performed automatically.