I use a TwwDBGrid with programmatically filled columns:

with MyGrid.Selected do
begin
Clear;
Add('DEBITOR' + #9 + '14' + #9 + 'Deb' + #9 + ');
Add('ARTICLE' + #9 + '16' + #9 + 'Article' + #9 + 'T');
end;

I use a TwwSearchDialog with the same selected property.
If I use the SearchDialog and search for a not existing value then an
error shows up with "Column unknow DEBITOR".

The column DEBITOR is fetched with this TIBOquery:

SELECT IVR_VERKP.DEB_KEY
, IVR_DEB.AFK AS Debitor
, IVR_ART.AFK AS Article
FROM IVR_VERKP
JOIN IVR_DEB ON IVR_DEB.P_KEY = IVR_VERKP.DEB_KEY
JOIN IVR_ART ON IVR_ART.P_KEY = IVR_VERKP.ART_KEY


I traced down the problem and figured out that it is concentrated on
the properties KeyLinks and KeyRelation of the TIBOQuery in
combination with the aliassed fields. If I remove the contents of
KeyLinks and KeyRelation, all goes well. If I don't, and in my
application I do need them, an error arises if I ask for a non
existing value.

Any ideas?
tia,

Gerard


Gerard J.M. Houtenbos
DoubleWood Software
_________________________

Gerard J.M. Houtenbos
DoubleWood Software