Re: [sqlite] SELECT ... FOR UPDATE

SQLite does not use row level locking, only file level locking. You can use BEGIN IMMEDIATE to exclude writers or BEGIN EXCLUSIVE to exclude readers and writers. If you do not explicitly start a transaction, each statement constitutes it's own transaction. -Ursprüngliche Nachricht- Von:

Re: [sqlite] SELECT ... FOR UPDATE

On 24 May 2016, at 8:04pm, Igor Tandetnik wrote: > SQLite will report a syntax error. That's pretty easy to confirm > experimentally. Download the command line shell tool as a "precompiled binary" for your platform: and test commands to your heart's co

Re: [sqlite] SELECT ... FOR UPDATE

On 5/24/2016 1:34 PM, Scott Doctor wrote: SELECT field FROM table FOR UPDATE; My question is, looking through the sqlite documentation, it is not clear how sqlite will handle that statement. SQLite will report a syntax error. That's pretty easy to confirm experimentally. -- Igor Tandetnik _

Re: [sqlite] SELECT FOR UPDATE

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