Subject | KeyDescLinks purpose? |
---|---|
Author | Claudio Valderrama C. |
Post date | 2001-03-18T02:14:05Z |
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
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