Thanks, But I step the instruction fellow the hint by offcial document by which said that's correct(BTW forgive me my poor english ): http://www.sqlite.org/concurrency.html 4.1 Read-only transactions BEGIN READ_ONLY; SELECT * FROM t1; SELECT * FROM t2; COMMIT;
4.2 Defer write locks BEGIN READ_INITIALLY; SELECT * FROM t1; SELECT * FROM t2; COMMIT; 4.4 Defer writes BEGIN DEFER_WRITES; SELECT * FROM t1; -- Processing delay UPDATE t1 SET ... WHERE ... SELECT * FROM t2; -- Processing delay UPDATE t2 SET ... WHERE ... SELECT * FROM t3; -- Processing delay UPDATE t3 SET ... WHERE ... COMMIT; ...and so forth. I wonder that does do something with version? ----- Original Message ----- From: "Marten Feldtmann" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, December 18, 2006 3:00 PM Subject: Re: [sqlite] SQL error: near "READ_ONLY": syntax error > LuYanJun schrieb: >> Hi guy: >> what does the follow meaning? >> sqlite> BEGIN READ_ONLY; >> SQL error: near "READ_ONLY": syntax error > READ_ONLY is not a valid option for this command. > > BEGIN [DEFERRED | EXCLUSIVE | IMMEDIATE] > > Marten > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > >
