Re: [firebird-support] Multiple rows in a EXECUTE PROCEDURE

2012-08-20 Thread W O
RIGHT!!! Thank you very much. Walter. On Sat, Aug 18, 2012 at 10:00 PM, Paul Vinkenoog p...@vinkenoog.nl wrote: ** Hello Walter, With the following Stored Procedure: SET TERM ^ ; CREATE PROCEDURE TEST RETURNS( IDENTI TYPE OF COLUMN CLIENTS.CLI_IDENTI, NAME TYPE OF

Re: [firebird-support] Multiple rows in a EXECUTE PROCEDURE

2012-08-18 Thread Paul Vinkenoog
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