>>>>>> >>>>>>*: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 CurIctfer >>>>
DO WHILE .T. ME.Work() ENDDO