Hi,

> What is wrong here?
>
>

CREATE PROCEDURE NEW_PROCEDURE
AS
begin
SELECT FIELD1,FIELD2

>From TABLE1

/* What's the ">" character doing there? */

Where
FIELD1 > 68;

/* SELECT ... INTO??? */

suspend;

/* Why suspend without output parameters? And if
you want to return a multi-row resultset, better use
FOR SELECT ... FROM ... WHERE ... INTO :var1, var2/output1, output2 */

End

With regards,

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