Data type mismatch using ADOQuery and parameter in FR 6.8.6

After updating from FR 6.4 to 6.8.6 we have a problem using ADOQuery and parameters:

The query includes

WHERE Table.id = :p

In the parameter editor p is defined as an integer, so is the column "id" in the connected SqliteDB.


Everything worked fine in FR 6.4, but in 6.8.6 we get a "Data type mismatch" dialog and the report fails.

Setting the WHERE clause to a fixed value works, but using parameters doesn't. What's wrong?


Leave a Comment