hi!
is there a quick way to copy/move ALL records from table1 to table2 than looping through the records(from table1) and transfer it to the next table?
ptalbot wrote:Have a look at the rawSQL plugin, where you can use the executeSQL method to copy and notifyDataChange to tell your clients to reload the table based on the new IDs.
ptalbot wrote:You could use transactions (set databaseManager.setAutoSave(false) first) to insert many rows in one go instead of hitting the database for each new record.
You will still need to iterate on the source foundset though, create the new records on the target foundset, fill them with the source data and commitTransaction() after a certain number of rows...
Users browsing this forum: No registered users and 6 guests