AnsweredAssumed Answered

Unique value validation fails in multi-user environment

Question asked by RonnieRios on Jul 7, 2011
Latest reply on Oct 27, 2014 by CamdenNarzt


Unique value validation fails in multi-user environment


FileMaker Server


Operating system version

Mac OS X Server 10.6.7, Windows Server 2008

Description of the issue

Two concurrent users running a script are allowed to input the same value into two separate records in a field with validation set to require unique values.

Steps to reproduce the problem

On a shared database create a number field and turn on "Unique value" in validation options. Open the file from two separate computers, move to a layout based on the table that contains the field created.  Now run the following script on both computers simultaneously (it may take a few tries to get timing right):

Set Error Capture [On]
New Record/Request
Set Field [table::field; 42]
Commit Records/Requests [No dialog]

Have tested with Filemaker Server running on Windows and well as on Mac OS X.  Clients using either Filemaker Adv 9 or 11.  All with same results.

Expected result

One of the users is not allowed to commit it's record.

Actual result

Two saved records with the same value in the indicated field.