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

Re: [sqlite] prepare error

2006-05-19 Thread Kevin Piciulo
I tried without using a bound column name, that took care of it. Thanks Jay Sprenkle wrote: On 5/19/06, Kevin Piciulo <[EMAIL PROTECTED]> wrote: Hello, I've been staring at this line for quite a while now, and can't figure out what the problem is. I know the database is created and

Re: [sqlite] prepare error

2006-05-19 Thread drh
Kevin Piciulo <[EMAIL PROTECTED]> wrote: > Hello, > I've been staring at this line for quite a while now, and can't > figure out what the problem is. I know the database is created and > open. The following returns SQLITE_ERROR. > > sqlite3_prepare(m_dbDataBase, "UPDATE Users SET ? = ?

Re: [sqlite] prepare error

2006-05-19 Thread Jay Sprenkle
On 5/19/06, Kevin Piciulo <[EMAIL PROTECTED]> wrote: Hello, I've been staring at this line for quite a while now, and can't figure out what the problem is. I know the database is created and open. The following returns SQLITE_ERROR. sqlite3_prepare(m_dbDataBase, "UPDATE Users SET ? = ?

[sqlite] prepare error

2006-05-19 Thread Kevin Piciulo
Hello, I've been staring at this line for quite a while now, and can't figure out what the problem is. I know the database is created and open. The following returns SQLITE_ERROR. sqlite3_prepare(m_dbDataBase, "UPDATE Users SET ? = ? WHERE user_id == ?;", -1, , NULL); My guess is