Subject Setting a generator
Author Xavi (Sofinter)

I've created a generator that must have an inital value depending of a field max value.


Inside a SP a tried to select the max value, keep into a variable and then use the variable to set the generator value, but "set generator" or "alter sequenze" is not compatible in a stored procedure.


How can I set the generator using a variable or select max()?


Thank you,


Xavier Garcia