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.
