sequence generated for the primary key

[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

[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.

[roy]

praveenala, Please supply the DS version OS and is this Server or EE related.