IB Version is "6.0.1.0" Dialect is "3"
"MyDateVar" in Delphi is "tdate"
"MyDateField" in IBtable is "Date"
? "MySearchDate" ?
? Parameter is only defined in the Statement ?

regards Uwe

>>> Helen Borrie (TeamIBO<helebor@... ")"Newsgroups> 17.02.2002

10:41:01 >>>
At 02:27 PM 17-02-02 +0200, Uwe Cramer wrote:

>Hello,
>i clear and add the following statement in the query.sql
>the ParamCheck is true
>'select * from MyTable where MyDateField = :MySearchDate'
>when i set the params like
>Query.ParamByName('MySearchDate').asString := dateToStr(MyDateVar);
>or
>Query.ParamByName('MySearchDate').asDate := MyDateVar;
>i get the error -804
>
>i can�t see whats wrong and the same with a bde.querry to paradox table
>works fine.

..but this isn't Paradox..<g>

1. Please say which Version and Dialect of the database you are using.
2. What Delphi type is MyDateVar?
3. What FB/InterBase type is the parameter 'MySearchDate'?


regards,
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
www.ibobjects.com



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/