(ODBC Manager Library)
| Description: | Launches a transaction in the specified database connection. The transaction will be cached locally if it fails and then sent to the database after the next successful transaction. This module is designed to provide logging of values that must not be lost. |
| Returns: | Returns an object value for the transaction. |
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 | Transaction |
| Format: |
\ODBCManager\TransactionCached( ErrorPtr, CmdStr, DSN, UserName, Password[, BatchSize]) |
| Parameters: |
| ErrorPtr |
| Required. A Pointer to the error status. Always set valid on completion. |
| CmdStr |
| Required. The SQL command to be processed within the transaction. |
| DSN |
| Required. DSN of the database within which to start the transaction. |
| UserName |
| Required. A user name, if required to connect to the database |
| Password |
| Required. A password, if required to connect to the database |
| BatchSize |
| Obsolete. |
| 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. |
