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 Working with User Objects in Users Guide.
For more information about using the Transaction object in an application, see 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 |
---|---|
Constructor in PowerScript Reference |
When the user object is created |
DBNotification in PowerScript Reference |
When an Oracle 10g server sends a notification that a database operation has occurred |
DBError in PowerScript Reference |
When a database error occurs in the transaction |
Destructor in PowerScript Reference |
When the user object is destroyed |
SQLPreview in PowerScript Reference |
Occurs immediately before a SQL statement is submitted to the DBMS |
Transaction function |
Datatype returned |
Description |
---|---|---|
ClassName in PowerScript Reference |
String |
Returns the name assigned to the user object |
DBHandle in PowerScript Reference |
Long |
Returns the handle for your DBMS |
GetContextService in PowerScript Reference |
Integer |
Creates a reference to a context-specific instance of the specified service |
GetParent in PowerScript Reference |
PowerObject |
Returns a reference to the name of the parent object |
PostEvent in PowerScript Reference |
Boolean |
Adds an event to the end of the message queue of the user object |
SyntaxFromSQL in PowerScript Reference |
String |
Generates DataWindow source code based on a SQL SELECT statement |
TriggerEvent in PowerScript Reference |
Integer |
Sends an event to the user object and executes the script associated with the event |
TypeOf in PowerScript Reference |
Object |
Returns the type of the user object |