Data From MySQL to SQLite

Dr. Hawkins dochawk at gmail.com
Thu May 23 16:06:54 CDT 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