Apply my previously posted 'temporarily' fix and I think it will work like
FB.1.5
=====================================================

----- Original Message -----
From: "Jesus" <chuycova@...>
Newsgroups: egroups.ibobjects
To: <ibObjects@yahoogroups.com>
Sent: Tuesday, September 12, 2006 9:17 AM
Subject: Re: [IBO] Locate do not work with Firebird 2.0


> 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
>>
>>
>>
>>
>>
>
>
>
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
>
>
>