Skip 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.

Records in Use - Single User

Featured Replies

I have seen this problem in other posts - but it seems to be for multi-user environments.

Mine is only used by 1 person at a time - but still I am getting 'record in use' errors. They have started appearing after upgrading to FM7 - the majority when I am using the 'replace contents' script step.

I know there are additional locking features in FM7 - so what would I need to remember to fix this? Do I need to specifically use the 'commit record' step and things like that?

Thanks

I haven't seen this particular problem, but it would seem to me that if you were to launch the script from an uncommitted record and started the replace contents routine, that when the script came to that uncommitted record that you started from, it will interpret it as locked by you, the record's 'owner.' So I'd commit the record first and then proceed with the replace contents script.

Hope this helps,

Dan

Yes, you should specifically use the Commit Record step. It was a good idea in 6, it's critical in 7. Another factor is the possibility of 2 windows of the same data, one of which could have a cursor in an field after editing (just parking the cursor should not lock, but I believe it remains locked after editing until you click out or commit).

A new behavior in 7 is that you must use the commit record step in the master file after editing related records via a script, or the related records remain open. Easy to do, difficult to remember.

There is an excellent article about this by Ilyse Kazar in the migration_foundations.pdf paper, in the Support area at FileMaker.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.