Hi,

At June 3, 2003, 18:31, Lucas Franzen wrote:

> Joe,

>> I'm attempting to create a stored procedure. I've already tested the
>> SP with DSQL (using IB_SQL, formatted with different whitespace), and
>> it works fine.

>> What am I doing wrong???

> I don't think an IBOQuery is the appropriate component for
> DDL-statements (and not for using it with ExecSQL anyway).

> The best is to use a TIB_Script, but you could also give a TIB_DSQL a
> try.

I use TIB_Script for my update application. And, you have to use the
SET TERM statement to change the terminator character.

i.e.:
SET TERM !! ;
CREATE STORED PROCEDURE spname (inputparams)
returns (returnparams)
as
declare variable var_name var_type;
begin
your code line 1;
your code line 2;
end!!
SET TERM ; !!

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