Data From MySQL to SQLite

Dr. Hawkins dochawk at
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