B4J Question sqLite data Base Attach another database

[rgarnett1955]

Hi,

SqLite has the very useful ability to attach another database to the main database being used. This is particularly useful for inserting data from a table in one db into the table of another with a single query. If you don't use attached DB's you need two queries and an intermediate table. Not the most efficient way.

Sadly sqLite doesn't appear to have a PRAGMA query to do this. It must be done at the sqLite command level.

I couldn't find a way of doing attached tables in B4X, maybe there is, but is it possible to add this feature?

Best regards
Rob

 

[Erel]

How to attach 2 databases and...

How would I write a query to attach (or join) 2 databases (main1 and temp1) and then insert the records from temp1.table1 into main1.table1. It is easy when in the same database - "INSERT INTO table1 SELECT * FROM table2" - (structure same of course). I hope it is as easy as example above...

www.b4x.com