Subject | TIBOQuery ParamsByName SQL Error -804 data type unknown |
---|---|
Author | Uwe Cramer |
Post date | 2002-02-17T12:27Z |
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
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