Re: NULL in Master/Detail FORM 6.0

This is a problem because, at least in version 7.3, a null does not equal a null. Don't understand why but it is true. This version also has problems with blanks and nulls. Perhaps you could use some unique value instead of nulls-- all zeros all Z's or something that isn't normally used in your items.

In article <iv7llzzxvc.fsf_at_bcstec.ca.boeing.com>, Candy Robinson <candy_at_bcstec.ca.boeing.com> wrote:

> I have a master-detail form that contains as the primary key in the master,
> a unique constraint around 3 items. This way, one of the 3 items may be
> NULL. The data in the underlying database is correct, but when I query the
> master, the detail shows up incorrectly for those records containing a NULL
> in one of the 3 items. It contains all details for all combinations that
> don't have the item NULL. How do I get the detail to work properly for NULL
> values in the master? Thanks for any help! --Candy
>
> --
> Sandra (Candy) Robinson candy.l.robinson_at_boeing.com 972-659-2558

TIA Received on Thu Sep 09 1999 - 23:06:01 CEST