[sqlite] Reading committed / uncommitted records

2010-10-06 Thread Abhijeet Shiral
Following is the scenario 1. I have a cursor open for the table and records are being fetched. Here are the steps. - Prepare the statements - Perform sqlite3_step ( ). 2. In between with another statement handle if I update the table, here I am updating the record which is just fetches by my

Re: [sqlite] Reading committed / uncommitted records

2010-10-06 Thread Pavel Ivanov
2. In between with another statement handle if I update the table, here I am updating the record which is just fetches by my cursor mentioned in step 1. You shouldn't do that. It's a bad idea in general and it leads to undefined results in SQLite specifically. - Ultimately, its fetching