Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- RaSQL/B 6.1a for Clipper - <b>n_xtranon()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
N_XTRANON()
Start transaction

Syntax
N_XTRANON([<lConcurrent>])

Argument
If .T. is specified, then a concurrent transaction is started.  If .If you 
specify .F. or omit the argument entirely, RaSQL starts a "normal" 
transaction.

Returns
True if successful.

Remarks
N_XTRANON() begins a transaction, while N_XTRANOFF() ends a transaction. If 
the station or server abends prior to the end of the transaction, Btrieve 
will roll back all updates performed during the transaction.

In general, you should begin a transaction after you have locked all 
necessary records but before you start any updates. End a transaction after 
you have committed all updates to disk with N_XUPDATE and/or N_XINSERT.  If 
using the RDD, end the transaction after all updates have been written to 
disk with COMMIT. Unlock records after the end of the transaction.

A concurrent transaction requires Btrieve 6.x.  It enables other stations to 
read records from the file as long as they are not records being updated by 
the station involved in the transaction.  In a normal transaction, other 
stations will not be able to read any records in the file between the time 
the current station begins writing to the file and the time it ends the  
transaction.

Note
Do not call N_XUSE() during a transaction.


See Also: N_XTRANCAN() N_XTRANOFF()

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