WebSpeed
Developer’s Guide
DB Transactions in Code
The terms physical transaction and commit unit refer to the same concept as the WebSpeed database transaction. For example, in the previous scenario where you are adding customer records, each customer record you add is a database transaction. In Figure 9–1, each order-line you create is a database transaction.
Figure 9–1: Database Transaction Definition
![]()
The database transaction is undone (or backed out) if:
In either of these cases, WebSpeed undoes all work it performed since the start of the database transaction, as shown in Figure 9–2.
Figure 9–2: Database Transaction Undo Processing
![]()
So far, you have seen how a database transaction can be useful in a situation that involves only a single table. Database Transactions take on additional importance when you make database changes in multiple tables or records.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |