Hi,

At November 25, 2003, 08:18, kfoinfo wrote:

> Following the advice in the FB Doc I wrote:
> ----------------------------------------------------
> SET TERM ^^ ;
> CREATE PROCEDURE FORM2 (NVAL Double Precision, NDEC Double Precision,
> CTEXTSINGULAR VarChar(25) CHARACTER SET WIN1252, CTEXTPLURAL VarChar
> (25) CHARACTER SET WIN1252) returns (CRETSTRING VarChar(200)
> CHARACTER SET WIN1252) AS
>
> begin
> cretstring = cast(cast(:nval as varchar(20)) || cast(' ' as varchar
> (20)) || ... <UDF to choose the correct string-variable> ... as
> varchar(200));
> end
> ^^
> SET TERM ; ^^
> --------------------------------------------------------
> But there is no result returning to the calling statement:
> select * from form2(1,0,'String1','String2');
>
> Where is the error ? Any alternatives ?

You forgot to add a SUSPEND before the end of your SP, to make your SP
selectable. Otherwise, you would have to use EXECUTE PROCEDURE to
execute your SP and get the result.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)