reset specific sequence

Posted by Admin on 09-Oct-2009 04:26

hi..i just want to know way to reset a specific sequence?? for example i want to reset sequence NextOrdNum.. thanks in advance

All Replies

Posted by kevin_saunders on 09-Oct-2009 06:01

You want to use the 'CURRENT-VALUE' statement..

CURRENT-VALUE(NextOrdNum) = x.

This thread is closed