Subject Re: IB_LookupCombo Showing Blank Line (SOLVED)
Author raja_s_patil

Latest Update : Problem Solved.

Well the problem was with primary key domains.

In earlier Database the PK of lookup table was CHAR(6)
in new version of Database it was changed to VARCHAR(6).

After spending a day (today) and sleepless night yesterday
and numerous tests as of this time the problem is solved.
Now lookupcombo shows desired values.

I think IBO compares lookup value with padding and
compares with fetched lookup data which comes are trimmed
since PK domain was varchar.

In case where Lookup value was full six character long the
lookup combo was showing correct value (One of test revealed this)
which gave clue to think about looking at structures of both
old and new databases and immediately it was noticed that
PK domains have been changed to VARCHARS. Recreating new
database with updated domains and pumping test data we could
see IB_LookupCombo functioning as expected.

Hope this help others in case of some strange behaviour is
noticed with IBO.

Thanks and warm regards.


--- In, "raja_s_patil" <kpr.kolhapur@...> wrote:
> Hello,
> Set up is as follows.
> Delphi2007 IBO 4.9.14 WinXP -> Firebird 2.1 on remote Linux Machine in LAN.
> I am using IB_Lookup combo in a form which is copied from another project. In original project same form shows correct value and functions as expected with another database. When it is copied to
> new version Application project and connected to new version database it shows a blank line instead of looked up display value.
> I created a fresh test project and put fresh IBConnection and two query objects and established key lookup scenario but there also it shows a blank line in lookup combo. I dont know what is going wrong.
> The original project source has been created in delphi 5 with IBO 4.2HG long ago and has been working fine for many years.
> now new version of application on Delphi2007 being developed. First original project was ported to delphi 2007 and IBO 4.9.14 and is functioning as expected for past few months.
> Please help me in this regard.
> Thanks and warm regards
> Raja.