Field validation rule in VFP database

[StewartUK]

VFP9 SP2

I have a table of donations.

There are 2 date fields (one for GBP donations and one for foreign currency donations), at least one of which must have a date in it.

At the moment I have the rule

IIF(EMPTY(ForeignDate), NOT EMPTY(Date), .T.)

When trying to append a record, this is OK when field <Date> would not be empty, but an error is triggered when it is empty, but <ForeignDate> isn't.

Can someone advise me of what I should have as a rule or perhaps if I am misunderstanding rules or any other (relevant ) suggestions.

Thanks,

Stewart

 

[Mike Lewis]

Stewart,

The rule is OK, but you want it to be record validation rule, not a [/i]field[/i] validation rule.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[StewartUK]

Ah yes, I guess I should have been able to work that one out!

Thanks,

Stewart