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.