Is C/Front able to update mass records in batches, or will I have to loop thru a Recordset to update many records? If I have to loop thru records to update them, is C/Front going to be able to handle a couple of hundred thousand updates at a time? Thanks Devin W. McMahon, MCDBA
Hi Use the MODIFYALL command rec.RESET; rec.SETRANGE(field1,val1); rec.SETRANGE(field2,val2); rec.MODIFYALL(field3,val3); Hope this helps Paul Baxter
Hello Are you referring to CAL Code? I do not find a MODIFYALL function in C/FRONT Devin W. McMahon, MCDBA
You must use loop to modify all rec. Perfomance of Cfront is very similar to C/AL. I’m using CFront and updating more than 1000000 of records per day on our customer database.
Yes ok I did not read the question at all, it was the shock of actually seeing the site up for a change. Then I managed to post my reply twice even though the system said I had not replied at all as the server could not be reached. Oh well Paul Baxter