Data From MySQL to SQLite
m.schonewille at economy-x-talk.com
Thu May 23 17:17:09 EDT 2013
Is it possible to execute multiple SQL lines with revExecuteSQL now?
Economy-x-Talk Consulting and Software Engineering
Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other
colour spaces. http://www.color-converter.com
Buy my new book "Programming LiveCode for the Real Beginner"
On 5/23/2013 23:06, 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.
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
More information about the use-livecode