Re: Aggregates on DateTime fields

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 08/09/04 

Date: Sun, 08 Aug 2004 19:00:40 -0500

>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?

You don't say what database you are using?
I don't have any problem with a query like this that uses MS SQL server 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: Aggregates on DateTime fields
    ... In a simple parameterized query ... WHERE master_ID =:param1 ... In code set the parameter and open, the TField returned is not null, but has ... and without a linked control. ...
    (borland.public.delphi.database.ado)
  • Re: Time out
    ... The above procedure will return a data set in one second. ... The difference in speed could be in Sql Server: The parameterized query is optimized once and then stored in the procedure cache, so that every time you send the same query, even though the values of the parameters are different, it follows the same strategy. ... On the other hand, the non-parameterized version is optimized every time, which will be a little less efficient, but will always choose the best index according to the current index statistics. ...
    (microsoft.public.dotnet.languages.csharp)
  • Date/Time Stamp
    ... I have some code set up to run a process that opens a a word document (mail ... merge) and connects to a query as the datasource. ...
    (microsoft.public.access.macros)
  • Re: escape the and " chars to insert them onto an Access database
    ... using a parameterized query, and then just set the value of the parameter to ... Syntax error in query expression ... Object& executeResult)> at System.Data.OleDb.OleDbCommand.ExecuteCommandText ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to fill dataset with just one row at a time?
    ... If you use a stored proc or a parameterized query, ... parameter to the SelectCommand. ... If you do not know the primary keys in which to query for a single item at a ... Can any one adivse? ...
    (microsoft.public.dotnet.academic)