<< Click to Display Table of Contents >>
Manual > Control Reference > Other > Direct query database(SQL) control >
Method name
explanation
All common methods
For details, please refer to Common Methods.
Connect
Connect to the database.
DisConnect
Disconnect from the database.
ExecuteSQL
Run SQL.
QuerySQL
Get the records resulting from executing SQL.
BeginTrans
Start transaction processing.
CommitTrans
Called when the transaction is completed.
Rollback
Reverts the changes made by ExecuteSQL within the transaction.
SetQueryTimeout
Specifies the number of seconds before a query times out.
GetLastError
Gets the last error message that occurred.