Hi all
I have a list of fields that need to be confirmed as not being duplicate before I let the framework Save() to proceed further.
I know I can setup candidate indexes in VFP and unique constraints in FireBird but I want to be sure before I allow the Save() to proceed.
The list examples are like below
cBk, iNo
cName, cCity
tInvDateTime, cClientName
I did try to create a where clause but the whole thing started to get very complex, when various types of fields start getting involved, Double, Numerics, Date, DateTime, .... Plus I had to have it for both VFP and FireBird.
Is there any way to find out if there is a unique violation in VFP code?
Thanks.