At 12:32 AM 06-09-02 +0000, you wrote:

>Hi there,
>
>I'm creating a stored procedure, and I end it with SUSPEND; (last
>statement before the sp's END ^)
>
>But I get the error UNKNOWN TOKEN SUSPEND.
>
>I just read in the IB docs that SUSPEND should not be used in an
>executable procedure (which mine is) but I still don't understand
>why it says UNKNOWN TOKEN.

This isn't an IBO question. In future post such Qs to ib-support.

>Any ideas?

Yes - you have omitted something from the previous line in the procedure -
a bracket or semi-colon most likely. Look there. And take out SUSPEND.

Helen

>
>___________________________________________________________________________
>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/