Re: [sqlite] The best way to handle dynamic table creation

2008-02-21 Thread Neville Franks
Simon, Thanks for that. Just shows how new I am at SQL. Thursday, February 21, 2008, 9:01:22 PM, you wrote: SD> See "IF NOT EXISTS" in http://www.sqlite.org/lang_createtable.html SD> Rgds, SD> Simon SD> On 21/02/2008, Neville Franks <[EMAIL PROTECTED]> wrote: >> I need to create tables on the

Re: [sqlite] The best way to handle dynamic table creation

2008-02-21 Thread Simon Davies
See "IF NOT EXISTS" in http://www.sqlite.org/lang_createtable.html Rgds, Simon On 21/02/2008, Neville Franks <[EMAIL PROTECTED]> wrote: > I need to create tables on the fly which will persist across sessions. > These tables may or may not already exist. > > Calling sqlite3_exec( "create table

[sqlite] The best way to handle dynamic table creation

2008-02-21 Thread Neville Franks
I need to create tables on the fly which will persist across sessions. These tables may or may not already exist. Calling sqlite3_exec( "create table ..." ) for a table which already exists returns SQLITE_ERROR, which I assume can be returned for a range of different errors. You can check the