Re: Aggregates on DateTime fields
From: Dave Blake (barnswood_at_hotmail.com)
Date: 08/07/04
- Next message: Viatcheslav V. Vassiliev: "Re: Install/Config issues accessing SQL Server 2000"
- Previous message: Mike Shkolnik: "Re: how to make exchanges between sql server and xml document?"
- In reply to: Dave Blake: "Aggregates on DateTime fields"
- Next in thread: Brian Bushay TeamB: "Re: Aggregates on DateTime fields"
- Reply: Brian Bushay TeamB: "Re: Aggregates on DateTime fields"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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?
- Next message: Viatcheslav V. Vassiliev: "Re: Install/Config issues accessing SQL Server 2000"
- Previous message: Mike Shkolnik: "Re: how to make exchanges between sql server and xml document?"
- In reply to: Dave Blake: "Aggregates on DateTime fields"
- Next in thread: Brian Bushay TeamB: "Re: Aggregates on DateTime fields"
- Reply: Brian Bushay TeamB: "Re: Aggregates on DateTime fields"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]