|Subject||Re: [firebird-support] Auto increment|
>>Part 1, Part 2My suggestion would be to store current timestamp as part 2
>>What is the best way to solve this? I think I need a generator which
>>gets the last number (part 2) there is for a given entry (part1) and
>>increment that value.
but only if the part 2 sequence is supposed to represent the
creation order of the entries.
You can then (if required) generate an ordinal contiguous
number sequence however apart for listing re-ordering
I have yet to find a need for this.
Even in the case of listing re-ordering (MOVEUP/MOVEDOWN)
numbers do not have to be contiguous and a single
sequence (such as that created by a generator) will do the trick.