RE: [sqlite] Binding a column name?

2005-07-09 Thread Brown, Dave
Actually I doubt it can - since without the column name it can't create the prepared statement byte code, right? -Dave -Original Message- From: Brown, Dave [mailto:[EMAIL PROTECTED] Sent: Saturday, July 09, 2005 8:46 PM To: sqlite-users@sqlite.org Subject: [sqlite] Binding a column

[sqlite] Binding a column name?

2005-07-09 Thread Brown, Dave
Is it possible for a bind variable to be a column name? I'd like to make a query which is: select from MyTable; and I'd like the column_name to be a bind variable. This doesn't work using the straight sqlite3_bind_text() call on the statement "select ? from MyTable;", which treats the column

Re: [sqlite] Error 21, "library routine called out of sequence"

2005-07-09 Thread Gé Weijers
On an almost pedantic note: declare the variable as: static volatile sig_atomic_t bKilled = 0; "volatile" keeps the compiler from caching the value in a register, and not noticing its change, and "sig_atomic_t" is an integer type guaranteed to be written in one instruction. Some

Re: [sqlite] how to force a database to be corrupted

2005-07-09 Thread Ulrik Petersen
Hi Olivier, Olivier Singla wrote: Hi, I was wondering, is there is way to force a database to be corrupted ? (obviously I need this for testing purposes). Basically I'd like to patch the database so the next sql command will return SQLITE_CORRUPT. You might want to look at: