Thank you, that fixed the problem. Kavita ----- Original Message ----- From: "Pavel Ivanov" <[email protected]> To: "General Discussion of SQLite Database" <[email protected]> Sent: Monday, September 21, 2009 11:33:35 AM GMT -06:00 US/Canada Central Subject: Re: [sqlite] Prepare Error from sqlite
> "CREATE TABLE EntityTbl (ID INTEGER PRIMARY KEY AUTOINCREMENT,AttrName > VARCHAR(50) COLLATE NOCASE,AttrEnum INTEGERAttrType INTEGER,AttrValue > VARCHAR(128) COLLATE NOCASE,ReadWrite VARCHAR(10),Entity_id INTEGER" In this sql string you're missing closing parenthesis at the end and apparently you also miss comma before AttrType. Pavel On Mon, Sep 21, 2009 at 12:22 PM, Kavita Raghunathan <[email protected]> wrote: > > I just put in my sqlite wrappers and started testing. > > I get the following error and when I stepped into the sqlite code, its when > sqlite3VdbeFinalize is called: > "prepare error: near ",": syntax error" > > > I was trying to do a "sqlite3_prepare_v2" and was using the following > sqlstring and the following wrapper > "CREATE TABLE EntityTbl (ID INTEGER PRIMARY KEY AUTOINCREMENT,AttrName > VARCHAR(50) COLLATE NOCASE,AttrEnum INTEGERAttrType INTEGER,AttrValue > VARCHAR(128) COLLATE NOCASE,ReadWrite VARCHAR(10),Entity_id INTEGER" > > > Anyway I can get a more descriptive error ? > Thanks! > Kavita > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
