| Subject | RE: [IBO] Problem with parameters in query |
|---|---|
| Author | |
| Post date | 2017-08-30T18:46:10Z |
Jason,
I can send you a demo app tomorrow, as it is already late here, but I am sure, you can reproduce it by just making a query like the example I used in my first post.
Just connect to a database with a table with a varchar or date field and assign something like that to the IBQuery.SQL.Text and call prepare.
Select * from table1 where :parameter1 = '' or table.varcharfield1 = :parameter1
It also works with something like that:
Select * from table1 where :parameter1 = '31.12.1899' or table.datefield1 = :parameter1
Anything like that should bring up the error.
I think it is raised by TIB_Row.AreParamsDuplicate in the unit IB_Components.
Maybe you could take a look at it.
Regards
Helmut