Re: [sqlite] Differentiate between CREATE TABLE failures (Exists vs Other Failures?)

2014-01-22 Thread Jeffrey Walton
- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jeffrey Walton > Sent: 21 January 2014 17:54 > To: sqlite-users@sqlite.org > Subject: [sqlite] Differentiate between CREATE TABLE failures (Exists vs > Other Failures?) > > My sta

Re: [sqlite] Differentiate between CREATE TABLE failures (Exists vs Other Failures?)

2014-01-22 Thread Dave Wellman
lite-users@sqlite.org Subject: [sqlite] Differentiate between CREATE TABLE failures (Exists vs Other Failures?) My startup routine attempts to create all needed tables in my database. For example: sqlite3_extended_result_codes(db, 1); ... int rc; char* err = NULL; const char* stmt = "CRE

[sqlite] Differentiate between CREATE TABLE failures (Exists vs Other Failures?)

2014-01-22 Thread Jeffrey Walton
My startup routine attempts to create all needed tables in my database. For example: sqlite3_extended_result_codes(db, 1); ... int rc; char* err = NULL; const char* stmt = "CREATE TABLE users ( " " userid INTEGER PRIMARY KEY AUTOINCREMENT, " " username TEXT, usergroup TEXT,