In my SQLite Delphi 10 project multiple parameters are not working anymore.
Example:
Code: Select all
select * from table_a
where (:para1 is null or field1 = :para1)
and (:para2 = 0 or field2 = :para2)
But if param1 is date and param2 is integer it is not working anymore -> no results.
Any idea??
Best regards,
Werner