(ODBC Manager Library)
| Description: | Launches a transaction in the specified database connection. The transaction takes care of its own shut-down process. |
| Returns: | Nothing |
Usage:  |
Script Only. |
| Function Groups: | ODBC |
| Related to: | AddConnection | BuildDelete | BuildInsert | BuildSelect | BuildUpdate | ConvertToDbDate | ConvertToDbTime | ConvertToDbTimeStamp | ConvertToVTSDate | ConvertToVTSTime | ConvertToVTSTimeStamp | CopyRecords | DBDropList | DBGridList | ErrMessage | ExecuteQuery | ExecuteQueryCached | FlushCache | FormatBatchQuery | GetConnList | ResultFormat | StatsWin | TableSynch | TransactionTransactionCached |
| Format: |
\ODBCManager\Transaction( TransObjPtr, ReadyPtr, TErrorPtr, CallerObj, UseTrans, DSN, UserName, Password) |
| Parameters: |
| TransObjPtr |
| Required. A Pointer to the transaction object |
| TReadyPtr |
| Required. A Pointer to a variable, used to set the ready status |
| TErrorPtr |
| Required. A Pointer to a variable, used to set the error status |
| CallerObj |
| Required. The object value of the original calling module |
| UseTrans |
| Required. Set to true (1) to use BEGIN and END of transaction |
| DSN |
| Required. DSN of the database to start transaction within |
| UserName |
| Required. User name, if required by the database |
| Password |
| Required. Password, if required by the database |
| Comments: |
This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above. The only way to ensure that a long running (or faulty) query does terminate is to set appropriate values for both the parameters ExecutionTimeout and UseDriverTimeout. Modules executing queries are designed to be run as launched modules and will remain active until complete. |
