Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Not Nulls and IIF Not working in DBC VFP6/SP4
Message
De
04/08/2000 16:41:41
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00401381
Message ID:
00401388
Vues:
21
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform