Page 1 of 1

sequence generated for the primary key

Posted: Fri Aug 19, 2005 3:16 am
by praveenala
Hi,

I have sequence generated for the primary key but if I want to start the initial value from 100 and increment by 1 how can I achieve it.

Please do reply ASAP

Thanks in advance

Regards,
Praveen

Posted: Fri Aug 19, 2005 3:23 am
by morneh
Execute the following from Administrator:

UPDATE SDKSequences USING DICT VOC SET F1 = '100' WHERE @ID = 'Your_Sequence_Name';

Then just use KeyMgtGetNextValue('Your_Sequence_Name') in the derivation for your primary key.

Posted: Sun Aug 21, 2005 5:35 am
by roy
praveenala, Please supply the DS version OS and is this Server or EE related.