Re: [sqlite] SQLITE_ERROR in sqlite3_prepare

2007-05-15 Thread Dan Kennedy
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]
-



[sqlite] SQLITE_ERROR in sqlite3_prepare

2007-05-15 Thread B V, Phanisekhar
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