DefOptions on Sequences

[thiago_farias]

Hi!

I want to configure a default value for sequence start parameter on physical data model. There is the DefOptions attribute, but I tried to set the value there and it didn't worked. How can I use this to set a start value for all new sequences on model?

Thank in advance!

[Ondrej_Divis]

Hi,

I suppose you mean "start with" value inside Physical Options in the Sequence properties. In order to achieve that, the easiest way for NEWLY created Sequences is to go to menu Database - Default Physical Options... - Sequence tab and set your desired options here.

If you need to do some fine tuning as well, you can define Initialize handler and do it by script. Setting initial value to any of Physical options is approximately one row of code:

obj.SetPhysicalOptionValue "<initial>/start with", 8

If you need to to maintain your ALREADY EXISTING Sequences, you have several options:

1. Create your own vbscript that will correct your existing Sequences as a one-time action
2. Create Custom check (with optional Automatic repair), that will check (and repair) your Sequences each time you run Check Model function
3. Create Validation handler, that will check proper setting of the "start with" value each time the Sequence is modified by any user...

This is what I like about PD a lot. PD almost always offers several different solutions to a given problem.

Kind Regards,

Ondrej Divis