Artur,

this is no SQL script. It is a SQL statement.

I never (have to) set the terminator.

In the past months I have been using Marathon v. 1.5 for a long time
this way.

Today I upgraded to v. 1.6 .

For 6 hrs Marathon worked flawlessly.

The moment I try to create the first stored procedure...

BANG! It won't accept it.

After the last message, I have tried the same code with IB_SQL (a
simple editor by Jason Wharton) AND IT IS EXECUTED OK.

Duilio

--- In ib-support@y..., "Artur Anjos" <arsoft@n...> wrote:
> Duilio:
>
> I think your problem is simpler, and related to Terminator. Did you
set the
> terminator well?
>
> Artur
>
>
> ----- Original Message -----
> From: "duilio_fos" <irel_llc@l...>
> To: <ib-support@y...>
> Sent: Monday, August 26, 2002 10:56 PM
> Subject: [ib-support] Re: problem with very simple Stored Procedure
>
>
> > > It's ridiculous
> >
> > You tell me.
> >
> > I was going to post my problem when I saw that a similar thread
was
> > already open.
> >
> > I am using Marathon v. 1.6 with FB v. 1.
> >
> > I want to re-create an old, simple, thoughly tested stored
procedure.
> >
> > The code is:
> >
> > CREATE PROCEDURE NewN_ROW
> > RETURNS
> > (result integer)
> > as
> > begin
> > result=GEN_ID(N_ROW_GEN, 1);
> > end
> >
> > N_ROW_GEN is a generator existing in my database
> >
> > The only different point I can see is that this time I am using
the
> > SQL editor of Marathon v. 1.6.
> >
> > When I try to execute the SQL statement, Marathon says:
> >
> > "unexpected end of command"
> >
> > Adding a final colon won't produce different results.
> >
> > Is there a bug in Marathon or I am doing some stupid error I
cannot
> > see ?
> >
> > TIA
> >
> > Duilio Foschi
> >
> >
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >