Subject Re: [IBO] Re: Lookup field problem
Author Helen Borrie
At 12:25 PM 22/08/2005 +0000, you wrote:
>Thank you Helen for a reply.
> > So the first thing to do will be to
> > remove that TIBOTransaction and just go with the internal
> > DefaultTransaction that is embedded in the IBODatabase.
>Interesting idea, but nothin's changed.
>I'll try to describe it again:
>Have manually defined lookup field on TIBOQuery:
>object IBOQueryDEPARTMENTNAME: TStringField
> FieldKind = fkLookup
> FieldName = 'DEPARTMENT'
> LookupDataSet = IBOTable
> LookupKeyFields = 'ID'
> LookupResultField = 'NAME'
> KeyFields = 'ID_DEPARTMENT'
> Lookup = True
>If i'll make a select with query, it will correctly return department
>name based on: department id stored in a query and relational id in
>open table, resulting the name of department.
>If i'll make an edit of ID_DEPARTMENT in the query, than post and
>commit, it will reflect changes: ID_DEPARTMENT-OK, but lookup field
>returns empty string (related table is still open).
>Tried to call some "RefreshLookupList" method of the field, but no
>Thank you for any hint.

Try this:

File : /Demo Apps/
Uploaded by : helebor <helebor@...>
Description : Demo of TIBO Lookups and Use of an Extra IBOTransaction

You can access the file at the URL: