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
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