>Hello,
>
>I would like to have a view parameter of a parameterized view as a column inthe view.
>
>Is this possible? If so: How?
>
>TIA
>Gerhard
Hallo Gerhard
So?
lcPara = 'muh'
SELECT;
CAST(lcPara as c(20)) as cPara;
Cur1.SomeField,;
Cur1.nOtherField;
FROM curIrgendwer as Cur1;
INTO CURSOR curResult;
WHERE Cur1.cFieldToAsk=lcPara;
?
Das CAST sorgt dafür das auch leere Zeichenketten und .NULL.. gewandelt wird.
Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]