Then you could use something like this:

GEN_ID (GENERATOR, NEWVALUE - GEN_ID (GENERATOR,0) );

----- Original Message -----
From: Thomas Steinmaurer
To: ib-support@yahoogroups.com
Sent: Wednesday, November 06, 2002 5:16 PM
Subject: RE: [ib-support] How can I set a generator value inside a procedure?


Giovani,

> You can use the command SET GENERATOR <generator> TO <value>;

Yes, but not in a stored procedure or trigger.


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]