Re: [sqlite] SQLITE_ERROR in sqlite3_prepare

On Tue, 2007-05-15 at 13:47 +0530, B V, Phanisekhar wrote: > Hello all, > > When I try to prepare the stmt for the query "PRAGMA > cache_size = ?" I am getting an SQLITE_ERROR. You can only use '?' in place of an SQL expression. PRAGMA commands take a literal string, identifier or

[sqlite] SQLITE_ERROR in sqlite3_prepare

Hello all, When I try to prepare the stmt for the query "PRAGMA cache_size = ?" I am getting an SQLITE_ERROR. Whereas it doesn't give error for queries like "select xxx from table where rowed = ?" where xxx is some combination of columns. Regards, Phanisekhar