Re: [sqlite] Prepare Error from sqlite

2009-09-21 Thread Kavita Raghunathan
Thank you, that fixed the problem. Kavita - Original Message - From: "Pavel Ivanov" <paiva...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, September 21, 2009 11:33:35 AM GMT -06:00 US/Canada Central Sub

Re: [sqlite] Prepare Error from sqlite

2009-09-21 Thread Pavel Ivanov
> "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

Re: [sqlite] Prepare Error from sqlite

2009-09-21 Thread Kavita Raghunathan
21, 2009 11:22:15 AM GMT -06:00 US/Canada Central Subject: [sqlite] Prepare Error from sqlite 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 &qu

[sqlite] Prepare Error from sqlite

2009-09-21 Thread Kavita Raghunathan
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