Data From MySQL to SQLite
Devin Asay
devin_asay at byu.edu
Thu May 23 17:36:51 EDT 2013
On May 23, 2013, at 3:06 PM, Dr. Hawkins wrote:
> 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.
I didn't mention that my data contains one field with long xml-formatted data, so to avoid conflicts with delimiters I have to use
… revDataFromQuery(numToChar(31),numToChar(30) …
Can my values list use non-comma delimiters?
Devin
Devin Asay
Office of Digital Humanities
Brigham Young University
More information about the use-livecode
mailing list