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. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ 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