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
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
