🚀 go-pugleaf

On 9 Aug 2004 02:58:58 -0700, "Francesco" <.> wrote:

>
>Hello, 
>
>I've a problem, a simple query like the follow give me the wrong result
>TOTAL=0
>
>
>ADOQuery1->Close();
>ADOQuery1->SQL->Clear();
>ADOQuery1->SQL->Add("SELECT COUNT(*) AS TOTAL FROM SCHEMAS WHERE
>DATAARR < :data1 AND DATAPAR >= :data1");
>ADOQuery1->Parameters->ParamByName("data1")->Value =
>StrToDate("13/08/2004");
>ADOQuery1->Open();
>
>
>if I do the same query but in this way, I've the correct result TOTAL=1
>
>
>SELECT COUNT(*) AS TOTAL
>FROM SCHEMAS
>WHERE DATAARR < CAST('13/08/2004' AS DATETIME)
>AND DATAPAR >= CAST ('13/08/2004' AS DATETIME)
>
>
>Is there any know problem using parameters with date fields, both
>fields DATAARR AND DATAPAR are defined as datetime (8).
>
>
Ciao Francesco

   prova con qualcosa del genere:

ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("SELECT COUNT(*) AS TOTAL FROM SCHEMAS WHERE
DATAARR < :data1_1 AND DATAPAR >= :data1_2");
ADOQuery1->Parameters->ParamByName("data1_1")->Value =
StrToDate("13/08/2004");
ADOQuery1->Parameters->ParamByName("data1_2")->Value =
StrToDate("13/08/2004");
ADOQuery1->Open();

Giuliano