The Transaction object specifies the parameters that PowerBuilder uses to connect to a database.
You can customize your own version of the Transaction object by defining a class user object inherited from the built-in Transaction object.
For more information about creating a custom Transaction object, see the section called “Working with User Objects” in Users Guide.
For more information about using the Transaction object in an application, see the section called “Using Transaction Objects” in Application Techniques.
|
Transaction property |
Datatype |
Description |
|---|---|---|
|
AutoCommit |
Boolean |
The automatic commit indicator. Values are: TRUE -- Commit automatically after every database activity. FALSE -- Do not commit automatically after every database activity. |
|
ClassDefinition |
PowerObject |
An object of type PowerObject containing information about the class definition of the object or control. |
|
Database |
String |
The name of the database with which you are connecting. |
|
DBMS |
String |
PowerBuilder vendor identifier. |
|
DBParm |
String |
DBMS-specific parameters. |
|
DBPass |
String |
The password used to connect to the database. |
|
Lock |
String |
The isolation level. |
|
LogID |
String |
The name or ID of the user who logs in to the server. |
|
LogPass |
String |
The password used to log in to the server. |
|
ServerName |
String |
The name of the server on which the database resides. |
|
SQLCode |
Long |
The success or failure code of the most recent operation. Return codes: 0 -- Success 100 -- Not found -1 -- Error (use SQLDBCode or SQLErrText to obtain the details) |
|
SQLDBCode |
Long |
The database vendor's error code. |
|
SQLErrText |
String |
The database vendor's error message. |
|
SQLNRows |
Long |
The number of rows affected (the database vendor supplies this number, so the meaning might not be the same in every DBMS) |
|
SQLReturnData |
String |
DBMS-specific information |
|
UserID |
String |
The name or ID of the user who will connect to the database |
|
Transaction event |
Occurs |
|---|---|
|
When the user object is created |
|
|
When an Oracle 10g server sends a notification that a database operation has occurred |
|
|
When a database error occurs in the transaction |
|
|
When the user object is destroyed |
|
|
Occurs immediately before a SQL statement is submitted to the DBMS |
|
Transaction function |
Datatype returned |
Description |
|---|---|---|
|
String |
Returns the name assigned to the user object |
|
|
Long |
Returns the handle for your DBMS |
|
|
Integer |
Enables the database secure connection |
|
|
Integer |
Creates a reference to a context-specific instance of the specified service |
|
|
PowerObject |
Returns a reference to the name of the parent object |
|
|
Boolean |
Adds an event to the end of the message queue of the user object |
|
|
Integer |
Changes the value of the transaction object property in the encrypted connection string |
|
|
Integer |
Specifies the encrypted string to be used during the database connection |
|
|
String |
Generates DataWindow source code based on a SQL SELECT statement |
|
|
Integer |
Sends an event to the user object and executes the script associated with the event |
|
|
Object |
Returns the type of the user object |
