The insert will not be allowed until the query is closed, so you can't get into this situation.
-T > -----Original Message----- > From: B V, Phanisekhar [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 06, 2007 8:01 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Does sqlite3_step searches for a row in the > table / or some results buffer? > > 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? > > > > Sqlite3_step is supposed to execute the statement pStmt, > either until a > row of data is ready, the statement is completely executed or an error > occurs. > > > > > > Regards, > > Phani > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
