DECLARE VARIABLE GEN_VALUE INTEGER;
/* procedure body */
GEN_VALUE = GEN_ID(generator_name, 1);

/*procedure body */

Saludos,

Eduardo Gamboa
(ECUADOR)

-----Original Message-----
From: frische_brise2003 [mailto:juemu@...]
Sent: Wednesday, February 18, 2004 12:10
To: firebird-support@yahoogroups.com
Subject: [SPAM] - [firebird-support] reading a generator value in a stored procedure - Bayesian Filter detected spam

Hi all,

here is my way to read a value from a generator
in a stored procedure (this is only a part of the SP):

DECLARE VARIABLE NUM_VALUE NUMERIC (18, 0);

/* Procedure body */
execute statement ( 'select gen_id(' || :gen_name ||
', 1)FROM rdb$Database' ) into :NUM_VALUE;

I wonder if there is an easier way???


Regards

Jürgen




Yahoo! Groups Links