Subject Re: Antw: Re: [IBO] TIBOQuery ParamsByName SQL Error -804 data
Author Helen Borrie (TeamIBO)
At 03:50 PM 17-02-02 +0200, Uwe Cramer wrote:

>i try to change from "tdate" to"tdateTime" and "asDateTime" but
>the error is the same. i also get the error if i use a "String" with
>"asString"and i got the error in the line
>Query.ParamByName('MySearchDate').asDateTime := MyDateVar;
>not later in the line with "open"
>can i set the param datatype before to avoid this errors?
>regards Uwe

Yes - I assumed you had done that already! Open the Property Editor of the Params property and enter the settings for your params there. For documentation, see the Delphi Help. This is a TDataset feature.

>i got the error not after "open"

That's right, you will get the error on the Prepare event, which occurs when you call the ParamByName() method.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at