Hi,

At January 13, 2006, 1:58 PM, heredia_fer wrote:

> This is the Delphi code for retrieving data from the query:
> IBOQuery1.ParamByName('FecIni').asDate := StrToDate('01/01/2005');
> IBOQuery1.ParamByName('FecFin').asDate := StrToDate('03/01/2005');
> IBOQuery1.ParamByName('Codigo').Value := 98;
> IBOQuery1.Active := True;

> I already checked the types and they're correct. So, I don't know
> what's the problem. Maybe my Delphi code...

Try:
IBOQuery1.ParamByName('FecIni').asDateTime := StrToDate('01/01/2005');
IBOQuery1.ParamByName('FecFin').asDateTime := StrToDate('03/01/2005');
IBOQuery1.ParamByName('Codigo').Value := 98;
IBOQuery1.Active := True;

I always use AsDateTime for dates, times and timestamps. The reason
may be because I had some problems using AsDate and AsTime.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)