Hi Gregory,
Unfortunatly, I do not have my programs in n-tier set up. I just have the vfp base class that does my adding, editing and deleting of records for me. I do my record checks on the form.
Thanks Anyway,
Beth
>hi Beth,
>
>Why not move the logic to the Record Validation rule
>
>- only one place
>- buffering does not matter in triggers and Record Validation rules
>
>you can use a combination of getfldstate(-1) and FieldChanged() below
>
>
>function FieldChanged(FieldName)
>
> do case
> case isnull(oldval(m.FieldName)) or Isnull(eval(m.FieldName))
> return (isnull(oldval(m.FieldName)) <> Isnull(eval(m.FieldName)) )
> otherwise
> return (oldval(m.FieldName) <> eval(m.FieldName))
> endcase
>endfunc
>