For now you can use custom SQL functions to do the job. What kind of file do you want to import from? I can help you with writing the function.
Drag&drop is also in TODO for 2.1.0, but I don't know if it will be in 2.1.0 or in 2.2.0. We will see.
INSERT INTO newTable SELECT FROM oldDatabase.oldTable;
I assume that SQLITE_SEQUENCE is not a regular table created by user
If a column has the type INTEGER PRIMARY KEY AUTOINCREMENT then a slightly different ROWID selection algorithm is used. The ROWID chosen for the new row is at least one larger than the largest ROWID that has ever before existed in that same table. If the table has never before contained any data, then a ROWID of 1 is used. If the table has previously held a row with the largest possible ROWID, then new INSERTs are not allowed and any attempt to insert a new row will fail with an SQLITE_FULL error.
Users browsing this forum: No registered users and 3 guests