Hi:

The only way that I found was to do the select like this:

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

Of course I have to change a lot of my querys in my programs.

Jesus Covarrubias

Jesus escribió:

> Hi:
>
> 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
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
> (Yahoo! ID required)
>
> mailto:IBObjects-fullfeatured@yahoogroups.com
>
>
>
>
>