Subject Locate do not work with Firebird 2.0
Author Jesus

I have an application that have a query with something, in the SQL
property, like this:

select d.*
from Data1 d
where d.data1=:data.

This query returns many records, between 0 to 100.

In the application I do something like this Iboquery.locate('ID',value,[]).

After this I get an error. The question is that the locate adds a line
in the SQL, with something like this: "and Data1.ID=value".

This behavior was correct in firebird 1.5 but not in Firebird 2.0

The question is, What Can I do to avoid this behavior?

Can I do something to avoid IBO generate a new SQL instruction?

Thanks for your help.

Jesus Covarrubias