Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

The 500 Record Problem

Featured Replies

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?

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.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.