ALTER PROCEDURE "SOS"."ValidateScrFields2"(in @fldNum integer)
begin
declare local temporary table tmp(
fldtoPOP integer null default 0,
errDesc long varchar null,
)
in system not transactional;
insert into tmp( fldtoPop,errDesc) values( @Fldnum,'errorxxxxxxxx') ;
select fldtoPOP,errDesc from tmp
end
I can read from vb the errDesc from the select.
If I change this procedure to a function with a return it pops the error I
describe earlier.
"Cor Ligthert" wrote:
Raulavi,
Can you show a sample from that procedure that ends with
Select errdesc
Cor