🚀 go-pugleaf

ADO Express converts :param into ?, so query you pass to server is:

SELECT COUNT(*) AS TOTAL FROM SCHEMAS WHERE
 DATAARR < ? AND DATAPAR >= ?

As you could see, there is 2 parameters. Use query SQL Server style
parameters (@param, with DECLARE), or pass 2 parameters with the same value.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Francesco" <.> ???????/???????? ? ???????? ?????????:
news:41174df9@newsgroups.borland.com...
>
> 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
>