Hello,
i need it to get a result from a DBFunction like this:
-----------------------------------------
create dbfunction testsuch (IN idf int, OUT testsuch varchar(256)) AS
VAR tmp char;
TRY
Select domain from dba.t_domains where did = :idf;
WHILE $rc = 0 DO
BEGIN
fetch into :tmp;
END;
CATCH
if $rc <> 0 then stop (150,'error on query');
SET testsuch = tmp;
-------------------------------------------
I will use the result for a Query like this:
select * from anytable where name = testsuch(1234);
I hope you can help me
Mario Schroen
