How to avoid inserting duplicate sequence no's, skipping no's for an updateable sequence field. [message #77763] |
Tue, 13 November 2001 13:42 |
Nowsheen
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
In a multi-record block there is a sequence number field, which should be unique, is allowed to update, no gaps are allowed(i.e no skipping no's) and the field is not null field on the data base and not part of a primary key.
For example, if we have 10 records displayed on the screen then, if by interchanging the seq. numbers also on the screen it should commit the records, without any duplications or skipping numbers. If there is any missing numbers in between or repeating no. then it should raise the error.
It should work for all scenarios like while Enter Query, Execute Query, Clear Form, Save & Exit.
So, do anybody knows the way to achieve this.
----------------------------------------------------------------------
|
|
|
|