Hello Walter, > With the following Stored Procedure: > > SET TERM ^ ; > > CREATE PROCEDURE TEST > RETURNS( > IDENTI TYPE OF COLUMN CLIENTS.CLI_IDENTI, > NAME TYPE OF COLUMN CLIENTS.CLI_NAME) > AS > DECLARE VARIABLE MYCOMMAND VARCHAR(80) ; > BEGIN > > MYCOMMAND = 'SELECT CLI_IDENTI, CLI_NAME FROM CLIENTS ORDER BY CLI_NAME' ; > > FOR EXECUTE STATEMENT :MYCOMMAND INTO :IDENTI, :NAME DO > SUSPEND; > > END^ > > SET TERM ; ^ > > I get multiple rows when executing it with the "Execute" option of the SQL > Manager. However just one row with ISQL or a program. > > EXECUTE PROCEDURE TEST; > > With ISQL or with a program the prior line show me just one row. > > Why that? And how can I get all the rows?
Since this is a selectable stored procedure, you should retrieve its output (a dataset) like this: select identi, name from test HTH, Paul Vinkenoog
