Look here - http://www.sqlite.org/lang_transaction.html
LuYanJun wrote: > 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] >>----------------------------------------------------------------------------- >> > >> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
