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 number as an argument, not an SQL expression. Dan. > Whereas it doesn't give error for queries like "select xxx from table > where rowed = ?" where xxx is some combination of columns. > > > > Regards, > > Phanisekhar > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
