Promotic
WikipediaLinkedInYoutubeTwitterFacebook

DbCommitTrans - method of object PmaAdo

Description:
Confirms transaction over connected database.
Syntax:
Object DbCommitTrans([String sParams])
Calling:
oDb.DbCommitTrans(sParams)
Parameters:
sParams[optional] (String) Additional parameters of the DbCommitTrans method. Entries are in KeyVal format, for example "return:map;".
"return:xxx;" (optional) - Specifies whether the method returned value is a map containing multiple values (new procedure) or a single value (old procedure). If not set, then the old procedure is used.
map - Returns a map (PmMap) containing multiple returned values (new procedure) (e.g. Result, AffectedRows, ErrorCode, ErrorText).
Return Values:
New procedure: Returns PmMap object with values in following items:
- "Result": empty value (the method does not return anything)
- "ErrorCode": numeric error code where the 0 value signals successful method execution (no error)
- "ErrorText": error text description
 
Old procedure: Returns empty value (the method does not return anything).
Note:
The DbBeginTrans method starts a new transaction over the connected database. All following operations over this database will be confirmed as complete transaction by the DbCommitTrans method or cancelled by the DbRollbackTrans method. The transaction must be supported by both the connected database and the provider.
Example:

History:
Pm8.03.09: Created
PROMOTIC 9.0.7 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice