Subject TIBOQuery ParamsByName SQL Error -804 data type unknown
Author Uwe Cramer
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.
Uwe