|
For the incremental method of filling, it is possible to specify
the initial value and how many times each value should be used. For
example, if you specify 3 as the initial value and 2 in the "times"
field, you will get the following sequence:3,3,4,4,5,5... Moreover,
you can specify step value and format of
generated value output.
For the incremental method there is an additional option allowing
you to specify that the sequence will be started from the next
value after that already existing in the database. In this case the
program calculates the maximum column value, increases this value
by one and uses this new value to start the sequence.
There are settings for this fill method:
- "Insert after last" means the program will find maximum
existing value of the column and generate values greater it.
Otherwise, the program will use "Starting with" value specified by
user.
- "Step" property will be added to current value at each step.
Negative values are acceptable for this parameter.
- Format defines the view of value.
This option is applicable for numeric values only.
- "Use each value" property defines how many times each value
will be used by the data generator.
- For date and time values step type (hour, day, minute, etc.)
can be specified.
Example: for "Starting with" is 5, "Step" is 3 and "Use each
value" is 2 and format "%03d" the following sequence will be
generated: 005,005,008,008,011,011,...
|