flex - Trying to attach a database to a currently open database but i'm getting an error saying ATTACH is not allowed from SQL -
I'm trying to connect to a database (db2.sqlite) currently open database (db1.sqlite) dB in 1 Tables in one of the tables in one of the tables, the rational way to do this is that I use the attached command and then select all from db2 and enter in db1: -
'C: Attach \ db2.sqlite 'as new data; Enter in Main.table1 * Choose from newData.table1
Both the database have the same table name (Table 1) and the exact same schema. To ensure that my syntax was correct, I tried it in the Firefox SQLite manager and everything worked perfectly.
Unfortunately, when I tried the same method in my air application, I found the following error: - "Attach
Is not anyone working?
< P> Many thanks Adam
to:
The following SQL elements and SQLite implementations are supported in some of the SQLite features, but are not supported in Adobe AIR. Most of this functionality is available through the methods of the SQLConnection class:
* ATTACH: This functionality is available through the SQLConnection.attach () method.
Comments
Post a Comment