Does anybody know how to catch in which field is duplicate key error when using
TryInsert() from FileManagerClass?
What I mean is, when I use
Access:File.Insert(), if there is duplicate key it shows you where. Message is:
Adding this record creates duplicate entry for the key: FILE:Key
Since I don’t want to see error message, I only want to catch which field is duplicate entry and save it in log, I am using
But how to get value of the field? I have tried with
GlobalErrors.GetError(), but it returns empty string.
Access:File.GetError.ToString() method, but I get compile error - No matching prototype available and Field not found: TOSTRING.
So, question is, what goes inside IF statement?
IF Access:File.TryInsert() <> Level:Benign ! What goes here to catch which field is duplicate value? END
Other solution is
DUPLICATE(), for every field. But that seems inefective, since
Insert() knows which field is duplicate value, so should
Thanks for any help.