Re: [sqlite] Is _reset() removes binding?

On 5/1/2013 7:30 PM, Igor Korot wrote: 1. Is the call to sqlite3_reset() removes the binding for the column a? No. You can use sqlite3_clear_bindings for that. 2. Do I need to call sqlite3_reset() at all? Yes. You can't bind parameters to an active statement. -- Igor Tandetnik

[sqlite] Is _reset() removes binding?

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, , 0 ) ) == SQLITE_OK ) { sqlite3_bind_int( stmt, 1, var1 ); for( int i = 0; i < 10; i++ ) {