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.

Permanently delete Corrupt Record

Featured Replies

A user pointed out to me a single record that every field is populated with "?" and can't be editted.

I read online that this is rare, but that it is a corrupt record.

I looked through the entire database, it is the only one like this.

So I looked though my backups, and found one with an intact copy of this record.

So now I have imported the record back in... works fine... but I can't seem to permanently delete the old corrupted record. I pressed "Delete Record" and it vanished... but whenever I do a search of the fixed one... the one with question marks reappears as well in the list.

Could that mean that the index hasn't refreshed since I deleted it?

If so, how do I reset the index....

The Recover command in FileMaker 10 has a "Use Advanced Options" button (after you select the file), where you can turn off all the checkboxes except "Rebuild field indexes."

The corruption may be more severe, however, in which case the recommended procedure is to Recover/rebuild the file, go to a clone of a good backup, and import the recovered data.

  • 3 months later...

The ?? may not really be a record (although sometimes they are). If you see ??'s rebuild all the indexes for the table, I think you will find that they vanish and records that may be there but couldn't be found with the find command will be found. 'course there may still be the problem of whatever currupted it in the first place.

(Once you rebuild the index you may have a duplicate record)

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.