[sqlite] Is _reset() removes binding?

[Igor Korot]

Hi, ALL,
Consider this code:

int var1 = 5, var2 = 10;
query = "SELECT * FROM foo WHERE foo.a = ? AND foo.b = ?;";
if( ( result = sqlite3_prepare_v2( handle, query, -1, &stmt, 0 ) ) ==
SQLITE_OK )
{
     sqlite3_bind_int( stmt, 1, var1 );
     for( int i = 0; i < 10; i++ )
     {
           sqlite3_bind_int( stmt, 2, var2++ );
           result = sqlite3( step );
           if( result == SQLITE_DONE )
               sqlite3_reset( stmt );
           else
               printf( "Error occur!" );
     }
     sqlite3_finalize( stmt );
}

1. Is the call to sqlite3_reset() removes the binding for the column a?
2. Do I need to call sqlite3_reset() at all?

Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users