Thanks guys, the SP compiles.

Dion.

-----Original Message-----
From: Alexander Khvastunov [mailto:ak@...]
Sent: Wednesday, January 16, 2002 6:50 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] SP????

> The problem seems to be at this line:-
> BEN_ID = GEN_ID( BENID_GEN, 1 );

No, it seems that the problem is here:

> set term ^ ;
> CREATE PROCEDURE INSERT_BEN AS BEGIN EXIT; END ^
>
> SET TERM ; ^

^^^^^^^^^^^^^^^^^^

> ALTER PROCEDURE INSERT_BEN ( BENEF_ID VARCHAR(15)

You should remove this SET TERM statement.
Or, alternatively, add another SET TERM after this one:

set term ^ ;
CREATE PROCEDURE INSERT_BEN AS BEGIN EXIT; END ^

SET TERM ; ^ <------------- remove this _OR_
SET TERM ^ ; <------------- add this

ALTER PROCEDURE INSERT_BEN ( BENEF_ID VARCHAR(15)

etc...

Hope, this will help...


Best regards,
Alexander Khvastunov

IBExpert - The Most Expert for InterBase and FireBird
http://www.ibexpert.com


___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/