B4J Question sqLite data Base Attach another database


Active Member
Licensed User
Longtime User

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


B4X founder
Staff member
Licensed User
Longtime User
Upvote 0