then you must be executing it not selecting it.
try EXIT; instead
Alan

> -----Original Message-----
> From: constantijnw [mailto:wolfs@...]
> Sent: Saturday, June 05, 2004 8:27 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Error executing sp
>
>
> --- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> > > > >
> > > > >[ 5-6-2004 11:28:36 ]
> > > > >CLOSE ROW CURSOR
> > > > >STMT_HANDLE = 14707356
> > > > >ERRCODE = 335544569
> > > > >
> > This is similar to cursor unknown
> >
> > > CREATE PROCEDURE USER_SESSION_START2 (
> > > ACCOUNTNAME VARCHAR(32),
> > > USERNAME VARCHAR(32),
> > > PASSWRD VARCHAR(32) )
> > > RETURNS (
> > > ACCOUNTID INTEGER )
> > > AS
> > > BEGIN
> > > ACCOUNTID = 0;
> > > END^
> > >
> > > I've executed the sp in IB_SQL's DSQL tab and the same error comes up.
> > >
> >
> > Have you tried using SUSPEND; after the assignment?
> > Alan
>
> Hi Alan,
>
> I know somebody doesn't like this at all, but my answer is: I did, to
> no avail.
>
>
>
>
> __________________________________________________________________
> _________
> 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 !
>
> Yahoo! Groups Links
>
>
>
>
>
>
>