3 Replies Latest reply on Jul 10, 2017 3:16 PM by TSGal

    Get( RecordModificationCount ) broken, always increments in FileMaker 16

    JEDtech

      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.