Data From MySQL to SQLite

Peter Haworth pete at lcsql.com
Thu May 23 18:40:46 EDT 2013


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.schonewille at 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 at 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>
>



More information about the use-livecode mailing list