Subject | Ordering using a Computed Column for Lookups |
---|---|
Author | Martin D. Berezaga |
Post date | 2002-09-27T20:12:02Z |
I have a SQL like:
select A.ID, ...., (select B.DESCRIPTION from B where B.ID = A.ID) as
A_DESCRIPTION
from A;
A_DESCRIPTION has it COMPUTED CheckBox checked.
So, A_DESCRIPTION is a computed column based on a singleton select used to
keep a description column up-to-date with a Lookup Dataset, which SQL is:
select B.ID, B.DESCRIPTION from B;
I'd like to enable ordering based on the computed column, using it in
OrderingItems/OrderingLinks. But I'm getting a 'Columns Unkown' error.
How can I do?
Thanks in advance.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------
_______________________________________________________________________
Yahoo! GeoCities
Tudo para criar o seu site: ferramentas fáceis de usar, espaço de sobra e acessórios.
http://br.geocities.yahoo.com/
select A.ID, ...., (select B.DESCRIPTION from B where B.ID = A.ID) as
A_DESCRIPTION
from A;
A_DESCRIPTION has it COMPUTED CheckBox checked.
So, A_DESCRIPTION is a computed column based on a singleton select used to
keep a description column up-to-date with a Lookup Dataset, which SQL is:
select B.ID, B.DESCRIPTION from B;
I'd like to enable ordering based on the computed column, using it in
OrderingItems/OrderingLinks. But I'm getting a 'Columns Unkown' error.
How can I do?
Thanks in advance.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------
_______________________________________________________________________
Yahoo! GeoCities
Tudo para criar o seu site: ferramentas fáceis de usar, espaço de sobra e acessórios.
http://br.geocities.yahoo.com/