Transaction object

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 chapter on user objects in the PowerBuilder Users Guide.

For more information about using the Transaction object in an application, see 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	When the user object is created
DBNotification	When an Oracle 10g server sends a notification that a database operation has occurred
DBError	When a database error occurs in the transaction
Destructor	When the user object is destroyed
SQLPreview	Occurs immediately before a SQL statement is submitted to the DBMS

Transaction function	Datatype returned	Description
ClassName	String	Returns the name assigned to the user object
DBHandle	Long	Returns the handle for your DBMS
GetContextService	Integer	Creates a reference to a context-specific instance of the specified service
GetParent	PowerObject	Returns a reference to the name of the parent object
PostEvent	Boolean	Adds an event to the end of the message queue of the user object
SyntaxFromSQL	String	Generates DataWindow source code based on a SQL SELECT statement
TriggerEvent	Integer	Sends an event to the user object and executes the script associated with the event
TypeOf	Object	Returns the type of the user object