Data From MySQL to SQLite

Peter Haworth pete at lcsql.com
Thu May 23 19:13:46 CDT 2013


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>


More information about the use-livecode mailing list