Data From MySQL to SQLite

Magicgate Software - Skip Kimpel skip at magicgate.com
Thu May 23 20:51:32 EDT 2013


Is this a one time event or or does the data have to live in both locations
and a constant synchronization happening?

SKIP


On Thu, May 23, 2013 at 8:13 PM, Peter Haworth <pete at lcsql.com> wrote:

> On Thu, May 23, 2013 at 4:33 PM, Peter Haworth <pete at lcsql.com> wrote:
>
> > put zero into tColNumber
> > repeat tNumRecs times
> >    repeat tColCount times
> >       add 1 to tColNumber
> >       get revDatabaseColumnNumbered(tID, tColNumber,tArray[tColNumber])
> >    end repeat
> >    revExecuteSQL SQLiteDBID,"INSERT INTO <tablename> VALUES" &&
> > tValues,"tArray"
> >    revMoveToNextRecord(tID)
> > end repeat
> > revExecuteSQL SQLiteDBID,"COMMIT"
> >
>
> Sorry, the "put zero into tColNumber" line should come after the "repeat
> tNumRecs times"
>
> Pete
> lcSQL Software <http://www.lcsql.com>
> _______________________________________________
> 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
>



More information about the Use-livecode mailing list