Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Make this into an expression?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00400612
Message ID:
00400638
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform