RIGHT!!! Thank you very much.
Walter. On Sat, Aug 18, 2012 at 10:00 PM, Paul Vinkenoog <[email protected]> wrote: > ** > > > 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 > > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
