Thank you Nando and Helen.

In the end I tried Nando's idea first and it worked. I will use Helen's
suggestion for some more complex applications where I haven't even tried to
think about the SQL yet.

It is disappointing that I can't achieve this in SQL. As part of the
software I have a custom report screen where the operator can enter their
own SQL (or more likely I send them the SQL). Now it would appear that they
can't necessarily get all the results they would like directly.

The other thought is to go with a UDF. I suppose they are there to make up
for SQLs shortcomings.

Thanks for your help,

Shane

----- Original Message -----
From: "Nando Dessena" <nandod@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, January 29, 2001 7:33 PM
Subject: Re: [IBO] Type conversion


> Shane,
>
> > The problem I have is that even though I can covert the type to a
date/time in the other controls, I can not display the values as a time/date
in the grid. The value is actually derived from a calculation and is a
double.
>
> have a look at TField.OnGetText/OnSetText; since you are using the
> TDataSet-compatible flavour of IBObjects, these events should be
> available (don't know if a native counterpart exists, but I would bet
> something on these lines must be in place somewhere).
> HTH
> --
> ____
> _/\/ando
>
>
>
>
>