Hi,

as you're already saying: RDB$GENERATOR_ID is NOT the generator value and
should NOT be updated.

Have you checked the SET GENERATOR command in the documentation? That's the
only way to update generator values.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com



Hi again
I have
GEN_SAMPLE_1 current value 50
GEN_SAMPLE_2 current value 150
GEN_SAMPLE_3 current value 250
GEN_SAMPLE_4 current value 350

I want change values from all generators witout use gen_id()
I thinking use some like that
UPDATE RSB$GENERATORS
SET RDB$GENERATOR_ID = 0
WHERE RDB$GENERATOR_NAME LIKE 'GEN_TESTE_%';

but RDB$GENERATOR_ID isn't RDB$GENERATOR_VALUE and the table have
only three fields "RDB$GENERATOR_NAME", "RDB$GENERATOR_ID"
and "RDB$SYSTEM_FLAG".

Where is storage the current value of generators?
How can I change it?




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]