I have a database field set with a validation of "Unique value".

I am trying to revise a script that loops thru all the records and updates the value in the field.

Currently, my script loop stalls when the value written in a record is not unique.  I want to bypass writing the updated value if not unique, but I can't find a way past the Filemaker error code 504.  All I can do is manually "Revert" to the original field value.

Suggestions?

31 minutes ago, JH Howland said:

All I can do is manually "Revert" to the original field value.

Why can't you capture the error and have the script do the reverting?

--
P.S. If you had searched for 'capture unique revert', you could have found this:
http://fmforums.com/topic/100315-preventing-duplicates-when-creating-new-records-using-set-variable/?do=findComment&comment=456712

 

Edited April 30, 20178 yr by comment

20 hours ago, comment said:

Why can't you capture the error and have the script do the reverting?

--
P.S. If you had searched for 'capture unique revert', you could have found this:
http://fmforums.com/topic/100315-preventing-duplicates-when-creating-new-records-using-set-variable/?do=findComment&comment=456712

 

Thanks comment.  The link you provided did the trick.  Great help.