🚀 go-pugleaf

Ohhps I forgot, I use MSDE 2000 with BCB 5.


> 
> 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).
> 
> 
> thanks, Francesco