Search results

  1. M

    SQLite "Database is Locked" when moving a list of records from one table to another

    Wow ... first I want to emphasize how much I appreciate your willingness to take the time for the careful explanation. I now understand exactly what you posted. Question 1: To build the ids list, is the LINQ query faster than "For Each" looping through the listviewCollection and building a...
  2. M

    SQLite "Database is Locked" when moving a list of records from one table to another

    Hi: Thank you very much for your answer. I'm not a great programmer, and I'm afraid I don't understand line 1 in your code. And the last part of line 2 is a bit fuzzy to me also. It looks to me that in line 1, you are building a sort of list of id numbers, then using that to append to the...
  3. M

    SQLite "Database is Locked" when moving a list of records from one table to another

    I have a Public Sub to move a collection of records from one table to another in the same SQLite database. First it reads the first record from strFromTable, then writes it to strToTable, then deletes the record from strFromTable. To speed things up, I've loaded the entire collection of records...
Top Bottom