You can use sqlite3_complete. It does not check the grammar. It just makes makes sure that command has a semicolin. Why you need grammar checking?
On Wed, Jul 2, 2008 at 11:03 PM, Umaa Krishnan <[EMAIL PROTECTED]> wrote: > Hello, > > I was wondering if there a way in sqlite, wherein I could validate the SQL > statement (for correct grammar, resource name - column name, table name > etc), w/o having to do prepare. > > Thanks in advance > > > > --- On Wed, 7/2/08, Alex Katebi <[EMAIL PROTECTED]> wrote: > From: Alex Katebi <[EMAIL PROTECTED]> > Subject: Re: [sqlite] Table Level Locking > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Wednesday, July 2, 2008, 7:21 PM > > This is the way I hoped it should work, and it does. > Thanks so much Igor! > -Alex > > On Wed, Jul 2, 2008 at 9:39 PM, Igor Tandetnik <[EMAIL PROTECTED]> > wrote: > > > "Alex Katebi" <[EMAIL PROTECTED]> > > wrote in message > > > news:[EMAIL PROTECTED]<[EMAIL PROTECTED]> > <[EMAIL PROTECTED]<[EMAIL PROTECTED]> > > > > > Below is a section from The Definitive Guide to SQLite book > > > Is this not valid any more for the newer releases of SQLite. > > > > This is not valid anymore. See the message from Dr. Hipp in this thread: > > > > > > > > http://archives.devshed.com/forums/databases-124/database-table-is-locked-again-sorry-2068902.html > > > > Igor Tandetnik > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users