Thank you very much Jonathan.
I had managed to figure this out about 30 minutes after making the post. I
must admit I was misled by the 'expression evaluation not supported.'
message devoid of any detail.
Apart from this my sojourn with Firebird is progressing well.
Regards
Jupiter
On Sat, Aug
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
Hi
What is the problem with the following code?
Thank you
SET TERM ^ ;
CREATE PROCEDURE SPTR
AS
DECLARE VARIABLE price INTEGER;
DECLARE VARIABLE price1 INTEGER;
DECLARE VARIABLE eid SMALLINT;
DECLARE VARIABLE bsum INTEGER DEFAULT 0;
DECLARE VARIABLE SCTN CURSOR FOR (
Select ID,DBR,CDR
From
Hi Farshid,
What is the problem with the following code?
Without examining it very closely, I see several problems:
CREATE PROCEDURE SPTR
You don't specify any output parameters. But the SUSPEND later on suggests that
you want to return something to the caller. So you need a RETURNS clause.