Re: [sqlite] Re: Re: Re: Does sqlite3_step searches for a row in the table / or some results buffer?

2007-06-07 Thread John Stanton
Igor Tandetnik wrote: John Stanton <[EMAIL PROTECTED]> wrote: Predictability is ensured by using transactions. By using BEGIN and COMMIT to make transactions atomic you enforce a predictable state. Not if you modify the same data you are iterating over, on the same DB connection and thus

[sqlite] Re: Re: Re: Does sqlite3_step searches for a row in the table / or some results buffer?

2007-06-07 Thread Igor Tandetnik
John Stanton <[EMAIL PROTECTED]> wrote: Predictability is ensured by using transactions. By using BEGIN and COMMIT to make transactions atomic you enforce a predictable state. Not if you modify the same data you are iterating over, on the same DB connection and thus within the same

Re: [sqlite] Re: Re: Re: Does sqlite3_step searches for a row in the table / or some results buffer?

2007-06-07 Thread John Stanton
Igor Tandetnik wrote: B V, Phanisekhar <[EMAIL PROTECTED]> wrote: Why it's unpredictable? Why can't the unpredictable be made predictable? Please feel free to submit a patch, if you believe it's that easy. Assume I update the column of a row that meets the criteria of some select stmt

[sqlite] Re: Re: Re: Does sqlite3_step searches for a row in the table / or some results buffer?

2007-06-07 Thread Igor Tandetnik
B V, Phanisekhar <[EMAIL PROTECTED]> wrote: Why it's unpredictable? Why can't the unpredictable be made predictable? Please feel free to submit a patch, if you believe it's that easy. Assume I update the column of a row that meets the criteria of some select stmt and I am yet to encounter