Managing Transactions in ESQL
The way Progress handles transaction processing differs between ESQL and Progress/SQL. Progress/SQL uses the same block-oriented transaction management model as the Progress 4GL. However, in Embedded SQL, a transaction begins when you call
sqllogin()
and continues until you execute one of these statements:You can include COMMIT WORK and ROLLBACK WORK statements anywhere in your application. Use the COMMIT WORK and ROLLBACK WORK statements frequently since all updated rows are locked until one of these statements is encountered. See the
esqldemo.cc
anddyndemo.cc
sample applications provided with your installation for information on how the COMMIT WORK and ROLLBACK WORK statements are used in ESQL.NOTE: If you callsqllogout()
before committing the current transaction, the transaction is rolled back.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |