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

Today is tomorrow's yesterday.