0 Replies Latest reply on Feb 26, 2009 7:18 PM by IDIOTA

    Simultaneous SELECT / UPDATE

      I am new to database, so this may seem like a stupid question.

      I have a large table (about 50Mb) with many records and I would like to read the records using a SELECT statement with prefetch, process the records with actionscript, then put the result back to the SQLite database before fetching the next result.

      How can I do that? Should I use two separate SQLConnection, one for SELECT and one for UPDATE? Can I run the UPDATE statement before the SELECT statement completes?

      Thanks a lot for your help!