Data From MySQL to SQLite

[Peter Haworth]

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>