JEDtech

Get( RecordModificationCount ) broken, always increments in FileMaker 16

Discussion created by JEDtech on May 23, 2017
Latest reply on Jul 10, 2017 by TSGal

Product and version FileMaker 16.0.1

OS and version: macOS Sierra 10.12.5

Browser and version (for WebDirect only)

Hardware: MacBook Pro 15 Mid-2014

Description

In FileMaker 15 and below if you open a record and commit it without making any changes it does not update the RecordModificationCount.  In Filemaker 16 it does.  If you also have a field in the table to auto-enter the Modification TimeStamp it does NOT update in either 15 or 16 verifying that the record was not in fact modified.

 

How to replicate

 

Add a script to any database with at least 1 record in it.  The script only needs 3 script steps:

     Open Record/Request

     Commit Records/Requests [ With dialog: Off ]

     Show Custom Dialog [ "Get( RecordModificationCount" ) ; Get( RecordModificationCount )

 

Run the script in FileMaker Pro 16.  The number will increment with each running of the script.

Run the script in FileMaker Pro 15 or below.  The number will not increment.

 

For additional confirmation add a TimeStamp field to the table to track the Modification TimeStamp.  It will not change.

 

Workaround (if any)

 

None known.  This problem is breaking a solution that has been running smoothly since FileMaker 11.

Outcomes