Hi Paolo,

you should never change Generators since they are
normally used to provide unique (key) values.

However, just call a SQL script containing

>>>

GEN_ID( MyGenerator, -200 );
<<<
This would set your generator 200 values back or use

>>>

GEN_ID( MyGenerator, - GEN_ID(MyGenerator, 0) );
<<<
to set it back to 0.

You can do this by calling the method "GeneratorValue" of a
"TIB_Query" as well:

>>>

i := IB_Query1.GeneratorValue( 'MyGenerator', 200 );
<<<

HTH,
Markus


At 21:15 01.01.2001 +0000, you wrote:

>Hi list,
>could anyone help me telling if it's possible to change, on the run,
>generators, and how?
>
>Thanks
>Paolo.