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
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