I have uploaded the sample application, database and images of the problem I
am having (Lookup_Err_Sample.zip).

Please advice me if anything else is needed.

Regards
Jay

----- Mensaje original -----
De: "Jason Wharton" <jwharton@...>
Para: <IBObjects@yahoogroups.com>
Enviado: Miércoles, 13 de Julio de 2005 11:17 a.m.
Asunto: RE: [IBO] Lookup Doesn't work properly

> You might try uploading a very simple sample app that demonstrates the
> problem to the files area of this group.
>
> Jason Wharton
> www.ibobjects.com
>
>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
>> Behalf Of Jose Ostos
>> Sent: Tuesday, July 05, 2005 1:28 AM
>> To: IBObjects@yahoogroups.com
>> Subject: Re: [IBO] Lookup Doesn't work properly
>>
>>
>> Sorry to hear that you are sick and to be bothering you.
>>
>> Please rest and get well.
>>
>> Regards
>> Jay
>>
>>
>> ----- Mensaje original -----
>> De: "Helen Borrie" <helebor@...>
>> Para: <IBObjects@yahoogroups.com>
>> Enviado: Martes, 05 de Julio de 2005 03:08 a.m.
>> Asunto: Re: [IBO] Lookup Doesn't work properly
>>
>>
>> > At 02:29 AM 5/07/2005 -0500, you wrote:
>> >>Helen,
>> >>Thanks for your response.
>> >>
>> >>I Tried exactly what you suggested (used a subquery on the
>> PROVART table,
>> >>changed the KeyDescLinks, and specified widths on the
>> lookup table) for
>> >>the
>> >>sake of testing, but the result is still the same.
>> >>
>> >>I am using the JOIN instead of the subquery because I need
>> to be able to
>> >>sort de PROVART data grid by the description with the
>> ability to do an
>> >>incremental search on it. The PROVART table is indeed an
>> editable set
>> >>since
>> >>I am using UpdateSql statements and the RequestLive=True
>> property. I have
>> >>verified that I can edit, insert and delete records without
>> problems.
>> >
>> > That is not the issue. The set is not updatable at all.
>> You have made it
>> > behave that way because of your xxxSQL additions. The
>> logic problem with
>> > the join is that, as soon as you cause the join key to
>> change, that record
>> > in the set ceases to exist. That's why you are seeing what you see.
>> >
>> > If you want the same data to support ad hoc search as well
>> as a static
>> > lookup, you could try using both the join AND the subquery;
>> but don't
>> > make
>> > the joined field a virtual field, and don't trying to use
>> the joined field
>> > for your KeyDescLinks. Use the joined field for the search and the
>> > subqueried one for the KDL.
>> >
>> > As I'm sick at the moment, I have no energy to revisit the
>> logic myself,
>> > but others are most welcome.
>> >
>> >
>> >>As for the lookup grid, I have set the width of the data
>> fields AND the
>> >>grid
>> >>itself and I still have the problem. The strange thing is
>> that it ONLY
>> >>happens the FIRST time I open the lookup grid, after that, it works
>> >>without
>> >>any problems.
>> >
>> > OK, I can't explain that and I can't reproduce it (IBO
>> 4.5B, Delphi 7,
>> > Win2K). Perhaps others can throw some light on it if you
>> provide details
>> > of your environment.
>> >
>> >
>> >>If it helps, I can upload or send you the screen images so
>> that you can
>> >>see
>> >>exactly what is happening.
>> >
>> > No thanks. The description is adequate.
>> >
>> > Helen
>
>
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
>
>
>
>