> > I have question. I have procedure, for example:
> >
> > CREATE PROCEDURE SQR(X INTEGER) RETURNS(RESULT INTEGER) AS
> > begin
> > Result=:x*:x;
> > suspend;
> > end
>
>
> Remove the suspend statement. You don't need it since there will never be
> more than one row returned.

Don't make it confusing -- if the procedure is called via a SELECT, use
SUSPEND.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com