Subject KeyDescLinks purpose?
Author Claudio Valderrama C.
What's the idea behind KeyDescLinks? In my old applications I didn't use
this setting. I would say NEVER to be exact. Now I found that the help file
says it helps when using a lookupcombo in a grid, but it doesn't go into
details. In the keyset dataset, I put
KeyLinks=>keyset.pk=master.linkfield
KeyDescLinks=>keyset.showfield=master.compfield

In master, the SQL is something like
select f1, linkfield,
(select showfield from keyset k
where keyset.pk = m.linkfield) as compfield
from master m

and m.compfield is marked as computed, of course. But when I use the
combobox in the grid, I get
"master.compfield not found".

I always wanted to be explicit by qualifying fields with table's names, but
it seems this case is an exception: using instead
KeyDescLinks=>keyset.showfield=compfield
in the keyset dataset solves the problem. Was this feature designed in this
way? What's the real purpose of KeyDescLinks?

C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://www.cvalde.com