Re: [sqlite] validate SQL Statement

2008-07-05 Thread Rich Rattanni
es and locks appropriate resources. I need > to only check the sanity of the statement, and then discard. > > So I was wondering if there was a way to do it, instead of prepare statement > > --- On Thu, 7/3/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > From: D. Richard Hipp

Re: [sqlite] validate SQL Statement

2008-07-03 Thread Umaa Krishnan
ichard Hipp <[EMAIL PROTECTED]> Subject: Re: [sqlite] validate SQL Statement To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Thursday, July 3, 2008, 2:10 AM On Jul 2, 2008, at 11:03 PM, Umaa Krishnan wrote: > I was wondering if there a way in s

Re: [sqlite] validate SQL Statement

2008-07-03 Thread Alex Katebi
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

Re: [sqlite] validate SQL Statement

2008-07-03 Thread D. Richard Hipp
On Jul 2, 2008, at 11:03 PM, Umaa Krishnan wrote: > 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. You speak as if sqlite3_prepare() were a huge burden -

[sqlite] validate SQL Statement

2008-07-02 Thread Umaa Krishnan
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