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

Summary

Unique value validation fails in multi-user environment

Product

FileMaker Server

Version

11.0.3.309

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.

Outcomes