>>>> >>>>*:This is a temp cursor with xx,xxx amount of records, since I do not have access to the real data >>>>*:I just can't really now how many records there are, but most likely there are thousands >>>>select CurIctfer >>>>go top in CurIctfer >>>> >>>>*:This is basically a wrapper routine for the SQLPrepare() VFP function >>>>if !PrepareSql(pnHandle, "insert into mySQlTable (cuid,cbatcno,cjeid, cacctid,cdescript,creference," +; >>>> "cyear, cpdno, cstatus, csource, dtrs, ntrsamt, ctrstype, ctrsno, cobjno) values (?CurIctfer.cuid, " +; >>>> "?CurIctfer.cbatcno, " +; >>>> "?CurIctfer.cjeid, ?CurIctfer.cacctid, ?CurIctfer.cdescript, ?CurIctfer.creference," + ; >>>> "?CurIctfer.cyear, ?CurIctfer.cpdno, ?CurIctfer.cstatus, ?CurIctfer.csource," +; >>>> " ?CurIctfer.cTrs, ?CurIctfer.ntrsamt, ?CurIctfer.cTrsType, ?CurIctfer.cTrsNo, ?CurIctfer.cObjNo)") >>>> return .f. >>>>endif >>>> >>>>*:and here is where the inserts are made, goes record by record and inserts each one to the back end >>>>*:database >>>>scan >>>> if !SetSqlData(, pnHandle) >>>> return .f. >>>> endif >>>>ENDSCAN >>>> >>>>=UnprepareSql(pnHandle) >>>> >>>>>>>>
>>>>*:I would create a Remote view, NoDataOnLoad, base on the mySQlTable, Table Buffering >>>>Select mySQlTable >>>>APPEND FROM CurIctfer >>>>TABLEUPDATE() >>>>>>>>
>>>>*:This is a temp cursor with xx,xxx amount of records, since I do not have access to the real data >>>>*:I just can't really now how many records there are, but most likely there are thousands >>>>select CurIctfer >>>>go top in CurIctferCan't you do its creation directly on your BackEnd?
DO WHILE .T. ME.Work() ENDDO