On May 23, 2013, at 3:06 PM, Dr. Hawkins wrote: > Library??? assuming that the names/types are compatible, > > put revDataFromQuery(tab,vtab,inDbno,"SELECT * FROM inTable) into theData > > put "BEGIN TRANSACTION;" & cr into dcmd > > set the itemDel to vtab > repeat for each item theLin in theData > put "INSERT INTO outTable VALUES( " & theLin & ");" & cr after dcmd > end repeat > put "COMMIT;" & cr after dcmd > > revExecuteSql outDb, dcmd > > > You could also simply insert the values at each step of the loop, but > that's time consuming if you have a remote db.
Richard, Thanks, I'll give that a try. Any idea if this might work for records containing binary data? I have one table with around 74 MB of data that I need to transfer over. Devin Devin Asay Office of Digital Humanities Brigham Young University _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
