On Tue, 7 Feb 2006, [EMAIL PROTECTED] wrote: Thank you for your answer! Thanks the rest of you that gave me an answer to my problem!
Marian Olteanu <[EMAIL PROTECTED]> wrote:Is there a way in SQLite to use real prepared statements? Statements with variables, that you fill after you compile the query and reuse then reuse? I imagine something like: prepared_statement ps = db.prepare( "select * from tbl where c = %q' ); for( int i = 0 ; i < 100 ; i++ ) { ps.setValue(0,i); ps.execute(callback_handler); }http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob -- D. Richard Hipp <[EMAIL PROTECTED]>
