On Feb 14, 2006, at 4:31 AM, Jeff Ayling wrote:
On 14/02/2006, at 10:46 PM, Jeff Ayling wrote:
On 14/02/2006, at 10:22 PM, Marco Bambini wrote:
Hi Jeff,
the best solution is to attach the file based db to the in memory db
and then do a cross insert/select, like:
INSERT INTO fileDB.test1 select * from test1
// Dump all records from memory to disk
memDB.SQLExecute("BEGIN TRANSACTION")
memDB.SQLExecute("INSERT INTO fileDB.test1 select * from test1")
memDB.Commit
memDB.DetachDatabase("myFileDB")
In the INSERT above are there restrictions to the comp of select?
Eg, I'm having trouble getting the following to work:
memDB.SQLExecute("INSERT INTO fileDB.trax select * from trax As t1,
playlistdata As t2 where t2.Playlist_Persistent_ID IN (1,2,3,4) and
t2.Track_ID=t1.Track_ID and t1.web_enabled='Y'"
this select * gets more columns than those in just the TRAX table which
is likely the problem
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
