I think it depends on the SQL implementation. I don't think SQLite allows it, at least not in the SQLite library included in LC which is many releases old. I wonder waht RunRev plan to do when SQLite 4 is released.
Pete lcSQL Software <http://www.lcsql.com> On Thu, May 23, 2013 at 2:17 PM, Mark Schonewille < m.schonewi...@economy-x-talk.com> wrote: > 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<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<http://lists.runrev.com/mailman/listinfo/use-livecode> > _______________________________________________ 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