[sqlite] SELECT FOR UPDATE

[jfbaro]

Hi,

We are newbie to SQLite and we would like to lock a table through a select +
update.

Something like that:

BEGIN TRANSACTION
        
   currentValue = select currentValue from sequence_transactions;               
                
   update sequence_transactions set currentValue = currentValue + 1;
                
   COMMIT;

END TRANSACTION

When the program reachs the select, we would like other threads /
applications wait for that transaction to finish.

Is there any way of achiving that?

Cheers


-- 
View this message in context: 
http://www.nabble.com/SELECT-FOR-UPDATE-tf2645383.html#a7384913
Sent from the SQLite mailing list archive at Nabble.com.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------