Григорий Григоренко wrote:
> Let's say app does the following (via the same connection):
> 1. BEGIN TRANSACTION;
> 2. prepare and step stmt A (SELECT * FROM foo WHERE rowid=1), A is not
> finalized or reset;
> 3. execute stmt B (DELETE FROM foo WHERE rowid=1), B is prepared, executed
> and final
Fri, 19 Oct 2012 13:16:31 -0700 от Pavel Ivanov :
>>> Var Alice := Db.SelectRecord('SELECT * FROM client WHERE client_name = ?',
>>> [ 'alice' ]);
>
>>
>
>> 1. If I drop record for "alice" from db and then access column data in
>> prepared stmt will it work OK?
>
>
>
> If the select statement
Fri, 19 Oct 2012 15:49:07 -0400 от "Igor Tandetnik" :
>Григорий Григоренко wrote:
>
> I am using prepared stmts to cache selected record for later use. I have a
> wrapper class, that has methods like AsString(name),
>
> AsFloat(name) etc to extract data for a column name.
>
>
>
> I prepare,
>> Var Alice := Db.SelectRecord('SELECT * FROM client WHERE client_name = ?', [
>> 'alice' ]);
>>
>> 1. If I drop record for "alice" from db and then access column data in
>> prepared stmt will it work OK?
>
> If the select statement wasn't reset or finalized, you won't be able to
> delete a re
Григорий Григоренко wrote:
> I am using prepared stmts to cache selected record for later use. I have a
> wrapper class, that has methods like AsString(name),
> AsFloat(name) etc to extract data for a column name.
>
> I prepare, bind and then do Sqlite3_step() to get record. Later I use
> sqli
Hello,
I am using prepared stmts to cache selected record for later use. I have a
wrapper class, that has methods like AsString(name), AsFloat(name) etc to
extract data for a column name.
I prepare, bind and then do Sqlite3_step() to get record. Later I use
sqlite3_column_XXX() to access data
6 matches
Mail list logo
