|Subject||RE: [IBO] Display empty grid cell when boolean null instead of ?|
Is it possible you could insure False is put in the column instead of Null?
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Michael L. Horne
> Sent: Friday, April 29, 2005 2:35 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Display empty grid cell when boolean null instead of ?
> I have a grid where I am displaying the "Check" or "Blank" for
> a boolean value, but sometimes that boolean value is "Null"
> because it is being retrieved from another file and the record
> doesn't exist there.
> My users don't want to see the "?" which is drawn if the field
> if null. They would prefer to see a empty cell. They say it
> just distracts them from because they are looking for checks
> and it takes extra time to determine that it is a "?" instead
> of a check.
> Below is the SQL used to get the data, OM_SHIPRESIDENTIAL is the
> field that is causing the problem.
> How can I get it to display a "empty" cell instead of a "?".
> Michael L. Horne
> (select b.om_shipresidential from ordersm b
> where (UPS_RECONCILIATION.ur_om_id = b.om_id)) as
> FROM UPS_RECONCILIATION