Hi,
I have to update a running sqlite db with data from a second database
file, and wanted to use SQLConnection.attach, as descibed in:
http://livedocs.adobe.com/flex/3/langref/flash/data/SQLConnection.html#attach()
I can update data in both db's, but receive an error when I try to use
both.
Does anyone have a working sample snippet?
My Example:
var c : SQLConnection = new SQLConnection();
c.open(mainDbFile);
c.attach("otherDb", otherDbFile);
var s : SQLStatement = new SQLStatement();
s.connection = c;
s.text = "INSERT INTO main.t1 SELECT * FROM otherDb.t1";
s.execute();
