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.