> logically_deleted_yn= ;
> IIF(INLIST(logically_deleted_yn,"Y","N"),;
> logically_deleted_yn,.NULL.)
Steve,
Trey's answer to you is correct...
Your expression looks like an attempt to assign a value to logically_deleted_yn. No assignment is made in this expression; the total expression is evaluated.
Your expression will always evaluate to TRUE or NULL (never FALSE). It will evaluate to TRUE when logically_deleted = "Y" or "N", and to .NULL. in all other cases. The RI mechanism has been written to FAIL only on FALSE (as opposed to PASS only on TRUE).
For a discussion on this, see thread #
398289, where George talks about this apparent weirdness.
Steve Gibson