Hi there,

I was trying to access/use:

SELECT CURRENTVALUE FROM SYS.SYSSEQUENCES WHERE SEQUENCENAME='SOMETHING'

It appears not to return the expected value, in fact it seem to add 5 to the expected value or some other number but not what is expected.

Surely this cannot be considered correct/reasonable ?
Is there any way to access the real CURRENTVALUE (I don't think (CURRENTVALUE-X) is a good solution, since it is not clear what X should be at any one time)

Thanks,
Daniel Butler.