In the Field Validation Rule, put:
inlist(logically_deleted, "Y", "N")
>I simply used an 'or' in my iif... It wasn't working a minute ago, but it's working now, dammit.
>
>>I am trying to convert this Oracle Check Constraint into a VFP Field Validation Rule expression. The below code in Oraclespeak says to only allow the field to have a "Y" or "N" in it.
>>
>> Logically_Deleted_YN VARCHAR2(1) NOT NULL
>> CHECK (Logically_Deleted_YN IN ('Y', 'N'))
>>
>>
>>Thanks in advance for any help!
Mark McCasland
Midlothian, TX USA