SQLite attach db


#1

If I open two databases how can execute a query against two different tables, one from each db? I know SQLite supports the attach command how can I use that via AppStudio?

Thank you,
Robb


Multiple SQLite Databases
#2

I tried to do this with AppStudio back in 2013 but it didn’t work. You can check out the thread called “Multiple DBs Okay?” on the old Yahoo NSB forum if you’re interested. Message #16115 by Thomas Gruber may be if specific interest, though the entire thread has 20 entries in total. I haven’t tried to accomplish it again since then.

Kind regards,
Doug


#3

Here’s an answer:

https://stackoverflow.com/questions/15438149/is-it-possible-to-attach-an-sqlite-database-in-javascript

George Henne
NS BASIC Corporation
http://www.nsbasic.com


#4

I ended up loading both dbs using sqlopendb and then read both db’s into arrays.
I then combined arrays and then loaded into my grid. When I update/delete I am deleting out of only one db and then I reload both dbs to create union and refresh the grid.

Robb


#5

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.