Re: [sqlite] Way to "Bind" Columns in Prepare

On 7/30/06, michael cuthbertson <[EMAIL PROTECTED]> wrote: I need to embed variable column names in my queries, such as 'colX > '2004-01-01' where 'X' is a variable. bind_text will not do this. Is there another way? Yes, do another query. ;-) Seriously, note that if you change the condition

[sqlite] Way to "Bind" Columns in Prepare

I need to embed variable column names in my queries, such as 'colX > '2004-01-01' where 'X' is a variable. bind_text will not do this. Is there another way? Thanks. Michael

Re: [sqlite] outputting select in cpp file?

Clay Dowling wrote: > 1. Use the sqlite3 interface, not sqlite 2. > > 2. Store a 0 or a 1 in the field. Then you can get the value with > sqlite3_column_int > > There's a more complicated answer as well, but I wasn't able to get the > code assembled before it was time to turn in last night. >

Re: [sqlite] outputting select in cpp file?

Keiichi McGuire wrote: > This sounds like a very simple problem, but I cannot figure it out! > > Basically what I have is this settings table that has a boolean data > type, and I want to check it via a cpp program. > > sqlite_exec(db,"select flag from setting",0,0,); > > and I want to be able

[sqlite] Memory managment and B-Trees

Hello All: I have a question. I am trying to make SQLITE favor writing to disk than to store in memory with no luck!. I tried : sqlite3_soft_heap_limit(); rc = sqlite3_exec(ppDb,"PRAGMA cache_size = 10;",NULL,NULL,NULL); I tried to modify the page size, but with no