Is it possible you could insure False is put in the column instead of Null?

Jason

> -----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 ?
>
>
> Hello,
>
> 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 "?".
>
> Thanks
> Michael L. Horne
>
>
> select
> UR_ID,
> UR_POS_ID,
> UR_POM_ID,
> UR_OM_ID,
> UR_RECONCILED,
> UR_TRACK_NO,
> (select b.om_shipresidential from ordersm b
> where (UPS_RECONCILIATION.ur_om_id = b.om_id)) as
> om_shipresidential
> FROM UPS_RECONCILIATION