Checkboxes partially greyed out

Yes, it is due to the outer join - thanks for the tip. Now we need to refine the outer join :)


----- Original Message ----
From: Ken Williams <ken@...>
To: vantage@yahoogroups.com
Sent: Wednesday, April 30, 2008 12:52:09 PM
Subject: RE: [Vantage] Checkboxes partially greyed out


This can happen on outer-joined tables.

I had linked JobMtl to PO's. Not every Job Material has a PO, so they were outer-joined. The ones that do NOT have a PO any checkmarks from the PO table will show up gray checked on some screens. Others they show up with a solid square in them, I'm guessing this is based on each persons UI, but regardless, this where I've seen it. Null does not mean false, Null means Null.

____________ _________ _________ __

From: vantage@yahoogroups .com on behalf of Kunal Ganguly
Sent: Wed 4/30/2008 11:39 AM
To: Vantage Yahoo Group
Subject: [Vantage] Checkboxes partially greyed out

In a BAQ we are building for some records retrieved from the ship and order tables. Quite a few records show up as shaded checked checkboxes, instead of checked or unchecked. What do these shaded checkboxes signify? I thought the check boxes can only have two values - True or False. The actual value of the checkbox fields which are shaded in the SQL tables is neither true nor false, so they are essentially null, would that not be considered False?

Thanks,
Kunal

____________ _________ _________ _________ _________ _________ _
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile. yahoo.com/ ;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ <http://mobile. yahoo.com/ ;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

[Non-text portions of this message have been removed]
In a BAQ we are building for some records retrieved from the ship and order tables. Quite a few records show up as shaded checked checkboxes, instead of checked or unchecked. What do these shaded checkboxes signify? I thought the check boxes can only have two values - True or False. The actual value of the checkbox fields which are shaded in the SQL tables is neither true nor false, so they are essentially null, would that not be considered False?

Thanks,
Kunal



____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

[Non-text portions of this message have been removed]
Shaded columns are typically indicating that they are read only.

--- On Wed, 4/30/08, Kunal Ganguly <kunal_vantage@...> wrote:

From: Kunal Ganguly <kunal_vantage@...>
Subject: [Vantage] Checkboxes partially greyed out
To: "Vantage Yahoo Group" <vantage@yahoogroups.com>
Date: Wednesday, April 30, 2008, 1:39 PM






In a BAQ we are building for some records retrieved from the ship and order tables. Quite a few records show up as shaded checked checkboxes, instead of checked or unchecked. What do these shaded checkboxes signify? I thought the check boxes can only have two values - True or False. The actual value of the checkbox fields which are shaded in the SQL tables is neither true nor false, so they are essentially null, would that not be considered False?

Thanks,
Kunal

____________ _________ _________ _________ _________ _________ _
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile. yahoo.com/ ;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ

[Non-text portions of this message have been removed]
















____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Not that it helps in your particular situation, but in answer to your
last, no, not necessarily. There's a third choice - null, or
indeterminate. The question remains unanswered either way. It's a
necessary feature sometimes, since you might create the record before
all the data are known. Schroedinger's Cat applied to an electronic
database?

--- In vantage@yahoogroups.com, Kunal Ganguly <kunal_vantage@...> wrote:
>
> In a BAQ we are building for some records retrieved from the ship
and order tables. Quite a few records show up as shaded checked
checkboxes, instead of checked or unchecked. What do these shaded
checkboxes signify? I thought the check boxes can only have two values
- True or False. The actual value of the checkbox fields which are
shaded in the SQL tables is neither true nor false, so they are
essentially null, would that not be considered False?
>
> Thanks,
> Kunal
>
>
>
>
____________________________________________________________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
> [Non-text portions of this message have been removed]
>
This can happen on outer-joined tables.

I had linked JobMtl to PO's. Not every Job Material has a PO, so they were outer-joined. The ones that do NOT have a PO any checkmarks from the PO table will show up gray checked on some screens. Others they show up with a solid square in them, I'm guessing this is based on each persons UI, but regardless, this where I've seen it. Null does not mean false, Null means Null.

________________________________

From: vantage@yahoogroups.com on behalf of Kunal Ganguly
Sent: Wed 4/30/2008 11:39 AM
To: Vantage Yahoo Group
Subject: [Vantage] Checkboxes partially greyed out



In a BAQ we are building for some records retrieved from the ship and order tables. Quite a few records show up as shaded checked checkboxes, instead of checked or unchecked. What do these shaded checkboxes signify? I thought the check boxes can only have two values - True or False. The actual value of the checkbox fields which are shaded in the SQL tables is neither true nor false, so they are essentially null, would that not be considered False?

Thanks,
Kunal

__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ <http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]