Subject | change values in RSB$GENERATORS |
---|---|
Author | enio_bueno |
Post date | 2001-12-12T13:05:55Z |
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?
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?