Using a TIBOQuery through a TIBODatabase (version 4.21) with SQL something like:

select acode, aname from sometable
where acode like :s
or aname like :s

After about four changes of the parameter using parambyname (closing the query before change, then opening it) the query blows up.

If I change one of the :s parameters for :s1, thus it doesn't have the same parameter in the query twice, then it performs fine with absolutely no other changes.

Could there be a bug associated with the use of the same parameter twice?

Neville Richards


[Non-text portions of this message have been removed]