B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
Assume a query
"select * from table "
Let there be 10 rows in the table
Hence there will be 10 rows in the result corresponding to the above
query. We can get all these 10 rows by calling sqlite3_step 10 times.
Assume after 3 sqlite3_step calls, we insert a row into this table.
Now after insertion we call sqlite3_step for the instruction "select
* from table". Will this newly added row also get returned in this
case?
It may or may not. In general, it's unpredictable. In this particular
case, it will most likely appear at the end of enumeration, as an 11th
row.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
