Subject When is KeyRelation necessary?
Author Nando Dessena
I am using a TIBOQuery with a somewhat complex SQL statement (a left
join and a "where exists" clause). The dataset is not editable unless I
set KeyRelation. I thought that it was required when using implicit join
syntax only, while I am using explicit syntax.
Does anyone have a definitive reference on when is KeyRelation

The query is something like that:

select a.*,
from a left join b on ( =
where exists (select from some_stored_procedure(:a_param) s where =
order by

I have set KeyLinks to '', and thought that would be enough.
Setting KeyRelation to 'a' does work well, so it's not really an issue
for me, just a curiosity.