Data From MySQL to SQLite

Mark Schonewille m.schonewille at economy-x-talk.com
Thu May 23 16:17:09 CDT 2013


Hi Richard,

Is it possible to execute multiple SQL lines with revExecuteSQL now?

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

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" 
http://qery.us/3fi

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 mailing list