Subject | Re: [IBO] Re: Problems with parameters in subquery |
---|---|
Author | Lucas Franzen |
Post date | 2006-01-13T19:23:15Z |
>>>EConvertError: "01/01/2006 is not a valid INTEGER value".StrTodate returns a TDateTime type which is a double, not an Integer.
> 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');
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.