Unique value validation fails in multi-user environment
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]
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.
One of the users is not allowed to commit it's record.
Two saved records with the same value in the indicated field.