Subject Displaying updated values from JOINED columns
Author Clive Walden
I have a TIBOQuery with some joined fields for descriptions

== simplified snip ===
SELECT A.ID
B.NAME
FROM MAIN A
LEFT OUTER JOIN LOOKUP B
ON (A.ID = B.ID)
==========

This datasource for this dataset is linked to some edit fields and a DBGrid.

Unfortunately, after I edit the ID field in a TadvDBLookupColumnComboBox field the NAME field in the
Grid is not updated.

I have tried all different flavors of CommitAction and calling Refresh. Nothing seems to work other
than closing and reopening the Query.

I do not need to edit the NAME field. I do need its value to be updated after editing. Posting does
not help. Nor does scrolling back and forth to new records in the grid.

The ID field is correctly displayed with the new value.

Transaction.AutoCommit=True.

This is a conversion job from BDE.

Any help greatly appreciated.

Thanks,
Clive.
Clive Walden
Walden Consulting
Phone: 760-632-5856
Web site: www.clivewalden.com