SQLite and multiplie DB

Solar2D General Questions/Discussion
#1

Hi,
I have an application that requires more than one DB but that needs to link them together in order to execute some queries. I found an SQLite command called “ATTACH DATABASE” but it is giving me weird results. If I do “SELECT * FROM SomeTable” I get one record. If I do:

strSQL = “ATTACH DATABASE '”…system.pathForFile(“DB2.db”, system.DocumentsDirectory)…"’ AS DB2; "
strSQL = strSQL…"SELECT * FROM SomeTable as st LEFT JOIN DB2.SomeOtherTable as sot on st.Key1 = sot.Key1; "

I get no records, no message and nothing back. Even if the SomeOtherTable is empty, I should get the result of SomeTable, since my join is a LEFT join.

Help please. [import]uid: 97768 topic_id: 21014 reply_id: 321014[/import]

#2

Note that when I do this in a terminal session, it works beautifully, but when I do it using Corona, it does not. Doesn’t corona support the full version of SQLite? Does it not recognize the Attach Database command? [import]uid: 97768 topic_id: 21014 reply_id: 83542[/import]