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.

Two Global Calc bugs

Featured Replies

Using FM Server 7v3, I find two very serious bugs. Can anyone else confirm?

Bug #1

Make a global calculation field equal to a text constant, i.e.

kgKey1 = "Work" (calculation, global storage)

Add the field to a layout and verify that the field has the right value.

Now, go to table definition, duplicate the field definition, and change it, i.e.

kgKey2 = "Home" (calculation, global storage)

Add the field to your layout.

Notice that the field will not have the correct value. You must re-open the database for the global field to refresh to the correct value.

Bug #2

Global calcs that reference a summary on a self-relation hangs filemaker server.

Create a table with a self-Cartesian relation (i.e. the "X" operator). Put about 20,000 records in it.

Create a calculation with global storage that references this relation , i.e.

gcMaximumSerialNumber = Max(SelfRelation::Serial) (calculation, global storage)

Save changes. (sometimes you need to edit it again to see the bug)

At this point, Filemaker Server will go to 100% CPU, and stay there forever, even if you force-quit FileMaker Client. It appears to me that it either gets in an infinite loop, or perhaps it is trying (incorrectly) to evaluate the Max(SelfRelation::Serial) calculation for EVERY RECORD (even though this is a global calculation, which means it should only have to evaluate it once).

Beware global calculation fields!

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.