At 09:58 AM 29-01-01 +1100, you wrote:

>
>I am using an IBOQuery to populate a TDBGrid with data (as well as some
>other controls that are not reproduced in IBObjects).
>
>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.
>
>The SetFieldType is meant to do it for me but I noticed that it is not
>mentioned in the help file. Is it not supported in IBObjects and is there
>another technique I should be using?

Cast it as the appropriate type when you do the calculation in your SQL
statement, e.g.

select FieldA, FieldB, CAST(SomeValidExpression as Timestamp) as CalcDate,
more fields
from ATable

hth

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________