The 500 Record Problem

[vladisglad]

I wasn't quite sure which sub-forum this would go into so my choice was quite arbitrary.

I've had a problem with this for a long time and haven't heard from anyone despite searching the forums and google.

The issue is when manually performing a calculated replace on a field with over thousands of records. The little status window pops up and starts counting down how many records are left and too often it does the replace on the first 500 then just stall until cancel is clicked. Many times this forced me to omit 500 records a time and do the replace in batches, pretty annoying. 500 is the magical number of records which are processed before it stalls. Sometimes it stalls then picks up again, generally very flakey. Is it just us?

-This happens both if files are on a server or machine itself.

- Happens on FM9 & FM10

- Happens to different files and different tables.

Anyone experienced this?

[Vaughan]

Nope, never seen that. I'd start by assuming file corruption and saving a compressed copy of the file. If still bad, do a recover and see what happens.

I'd also change the calculated replace to a loop and Set Field with error trapping.