Re: Aggregates on DateTime fields

From: Dave Blake (barnswood_at_hotmail.com)
Date: 08/07/04


Date: Sat, 7 Aug 2004 07:55:39 +0100

I can be more precise about my problem. In a simple parameterized query

SELECT Min(Time_Column) FROM My_Details_Table
WHERE master_ID = :param1

In code set the parameter and open, the TField returned is not null, but has
an unusable value. Now link a data aware control to this query, run the same
code and you get a usable value. Run in debug and sometimes it works with
and without a linked control.

I just don't get it. Something to do with persistent verses dynamic fields
maybe?