There are two ways to handle database connections and transactions for the DataWindow control. You can use:
Internal transaction management
A separate transaction object
The two methods provide different levels of control over database transactions.
If you are displaying a PSR file in the control
You do not need to use a transaction object or make a database
connection if you are displaying a PSR file in the DataWindow control.
If you change the DataWindow object
If you change the DataWindow object associated with a DataWindow
control during execution, you might need to call the SetTrans or
SetTransObject method again.
PowerBuilder You always need to call one of the methods to set the transaction object.
Web ActiveX You need to call SetTransObject again only when you are using a separate transaction object.
These options are described in this section.