Subject Re: [IBO] Re: Problems with parameters in subquery
Author Lucas Franzen
>>>EConvertError: "01/01/2006 is not a valid INTEGER value".

> Metadata:
> TFCHorExamen.CFFecha DATE not null
> CFCodTema INTEGER not null
>
> This is the Delphi code for retrieving data from the query:
> IBOQuery1.ParamByName('FecIni').asDate := StrToDate('01/01/2005');

StrTodate returns a TDateTime type which is a double, not an Integer.

When it comes to dates I generally prefer to anything else than
StrToDate conversions.

If you can't won't use DateTime components for setting the date
parameter(s) then make sure to really pass an Integer by means of using
trunc () or round () or anyhing like this when applying the value.

Luc.