>VFP 6.0
>
>FUNCTION verfield
> DO CASE
> CASE ALLTRIM(UPPER(auth.authtype)) = "VISA"
> IF limit = 0 OR EMPTY(fund) OR EMPTY(account);
> OR ISNULL(fund) OR ISNULL(account)
> WAIT WINDOW "Can not allow that, fix it!"
> *Return .F.
> ENDIF
> ENDCASE
>ENDFUNC
>
>I am doing a "record validation" in the AUTH table to check the record instead of "field validation". Since the auth.authtype can be of different values, and different field requirements, I was told that this is the way to do it. Can you help me by adding suggestions or advise? The WAIT WINDOW is just for a test, I will have to do something that would cause the cursor to remain in that record if error (not allow to leave until corrected). Along with that, how can I make it so that is hitting the key, it would return it all back (or if it was a new record, it would just delete that record)? Do I need the EMPTY and ISNULL at the same time? This coding above is in the MODIFY DATABASE, "Edit Stored Procedures".
>
>Thank you.
>
Chuck,

As far as needing both EMPTY() and ISNULL() the answer is yes. If a field is null EMPTY() will return .T.

George

Ubi caritas et amor, deus ibi est