Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Advantage CA-Clipper Guide v5.5 - commit transaction http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 COMMIT TRANSACTION
 Indicates the end of transaction and saves updates
------------------------------------------------------------------------------

 Syntax

     COMMIT TRANSACTION

 Description

     This command ends a transaction and tells Advantage to commit all
     the updates issued during the transaction to the table(s)
     and indexes. COMMIT TRANSACTION can only follow a corresponding
     BEGIN TRANSACTION command.

     Besides marking the end of a transaction, the COMMIT TRANSACTION
     statement signifies that pending updates should be written to the
     tables, indexes, and memo files. The first step flushes pending
     updates in all Advantage work areas to the Advantage Database
     Server to be logged in the transaction log file. Next, all the
     updates in the transaction are made. These updates are made visible
     to all other users at this time.

     Note:  Do not confuse the Advantage TPS COMMIT TRANSACTION command
     with CA-Clipper's COMMIT command. COMMIT simply flushes CA-Clipper
     buffers on the client to the network OS for all work areas with open
     tables and index files. COMMIT TRANSACTION first performs a COMMIT
     to flush writes to the server transaction log files, but then
     actually performs all writes issued since the BEGIN TRANSACTION
     command was issued.

 Example

     See the example in BEGIN TRANSACTION.


See Also: BEGIN TRANSACTION ROLLBACK TRANSACTION AX_Transaction()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson