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 User’s 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 that will be used to connect to the database.
Lock	String	The isolation level.
LogID	String	The name or ID of the user who will log on to the server.
LogPass	String	The password that will be used to log on 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.
Destructor	When the user object is destroyed.

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.