Data From MySQL to SQLite
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
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.
More information about the Use-livecode