Marian Olteanu 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);
}
Marian,see http://www.sqlite.org/capi3.html in particular section 2.2, Executing SQL statements.
HTH Dennis Cote
