Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not Nulls and IIF Not working in DBC VFP6/SP4
Message
From
04/08/2000 16:41:41
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00401381
Message ID:
00401388
Views:
20
>I created a DBC and then stuck a table in it. Then I made a primary key and
> some candidate keys. On all of the columns I am not allowing null values. In
> the field-level rule of a column called logically_deleted_yn (not a candidate
> or primary key), I have

> logically_deleted_yn= ;
> IIF(INLIST(logically_deleted_yn,"Y","N"),;
> logically_deleted_yn,.NULL.)

The field rule should return a logical value. If .F., then a field rule violation error (1582) will be thrown. Set the field rule to
INLIST(logically_deleted_yn,"Y","N")
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform