Database Commands SECTION 6 Functions and Methods
106
6-17-5 DBGetLastError
Description
Returns the last error string generated by the Database provider, and displays
it in a message box.
Syntax
returnstate = DBGetLastError(level, display)
Remarks
Typical Examples
DBGetLastError("Northwind")
or
DBGetLastError("Northwind", TRUE)
Both the above lines will get and display the last error to occur for the
Northwind connection.
ErrMsg = DBGetLastError("Northwind", FALSE)
The last error to occur for the Northwind connection is stored Text point
'ErrMsg', without displaying a message box.
6-17-6 DBMove
Description
RollbackTransAll Connection Cancels all changes and ends all
transactions.
TransCount Connection Returns the number of pending
transactions.
Requery Recordset Re-run the Recordset Query.
CancelUpdate Recordset Cancel a DBAddNew operation.
Find Recordset Find the specified criteria in a Recordset.
FinNext Recordset Combined DBMove("Next"), DBFind()
operation.
Source Recordset Modify the Recordset source.
Filter Recordset Apply a filter to a Recordset.
Save Recordset Saves a Recordset in XML format.
Command Connection
Level
Description
Argument Type Description
returnstate text The error message from the provider
level text A text point or constant specifying the
connection level. This must be a Connection
level.
display bool Optional flag. By default DBGetLastError will
display the providers error message in a
message box. Setting this flag to FALSE
prevents this action.