That would be fine, but how do I do it. This field is being
pulled from another file based on a field in this record, but
the second field doesn't have to contain a key. So how do I
write the SQL to make this value default to "F" if the other
record doesn't exist?

Thanks

Michael Horne

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of Jason Wharton
> Sent: Saturday, April 30, 2005 12:05 PM
> To: IBObjects@yahoogroups.com
> 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?
>
> 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
>
>
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>