Hi all,
I have a custom table say "XXXTable"
where field "RequestNumber" is mandatory - for which number sequence will be assigned
Scenario:
i am creating web service;where i assign all the field values
and ill do all the validations (including validate field, validate write) ; once if all the validations succeeded the record should be created
Problem is since the "RequestNumber" is mandatory i need to assign the number sequence value to it ; therefore if the user creating the records multiple times with error then number sequence will be used for that many error records;
NEED:
1. when i create a record with invalid data - number sequence value should be in free list (say number sequence value is HMA_003)
2. when i create a record with invalid data - number sequence value should be in free list
2. When i create a record with valid data - number sequence should use the value from free list (HMA_003 should be useD rather than using the value HMA_005)