Data From MySQL to SQLite

Dr. Hawkins dochawk at gmail.com
Thu May 23 17:06:54 EDT 2013


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



More information about the Use-livecode mailing list