you should always have the suspend; in there
even SQL Explorer does not like the absence of suspend
the unexpected end of command is the END statement since there is nothing
telling the parse to actually return or what to return
You might ilke to check the traffic with an sql monitor
I can highly recommend IBExpert too, there's a personal version for free -
at
http://www.hksoftware.net/download
this tool returns a result without the suspend but I would not omit the
suspend statement all the same.
Alan

-----Original Message-----
From: duilio_fos [mailto:irel_llc@...]
Sent: Tuesday, 27 August 2002 21:22
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: problem with very simple Stored Procedure


Alan,

> I have indeed and I get no errors

well, my copy of Marathon (version 16, build 16) won't execute that
statement (it won't execute _your_ statement, too).

The same old error message is given "unexpected end of file", plus a
new one "token unknown, line 3, char 1".

When I execute the original statement - using a different SQL editor -
FB will create the stored procedure and it will work also w/o
the "suspend" line.

Could you please state version, build and time stamp of your Marathon
copy ?

Thank you

Duilio





Yahoo! Groups Sponsor
ADVERTISEMENT



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]