Could you please elaborate your scenario? I tried a test myself but am afraid I may not have interpreted your test case properly.
I have 2 tables, fred and bob, each with 10000 rows. I select a column from fred and bind the value obtained from sqlite3_column_int to an update statement that operates on bob. I loop over fred via sqlite3_step, where each iteration successfully updates the row in bob. Both tables exist in the same DB, accessed via the same sqlite3 *. Have I misinterpreted your scenario somehow, as this works for me? Thank you for helping clear this up for me. -- Gerry Blanchette -----Original Message----- From: Ben Clewett [mailto:[EMAIL PROTECTED] Sent: Monday, April 18, 2005 4:50 AM To: [email protected] Subject: [sqlite] Locking Methods <snip> I am experiencing problems with the locking. Because SQLite uses database locking this forces two major problems: - I can't read through a record set and use the data to execute updates. For instance, some parsing exercise which cannot be completed using a single SQL command. I have to store all the data locally, get to the end of the query, then execute and update statements. Ben Clewett. </snip>
