Hi All,
How to auto increment user id with a custom logic The requirement is that Username Generation Rule should Auto increment as per following scenario:
Scenario :
1. Username creation needs to be in format : "AA8001"
2. Username should have fix length of 6.
3. At each user creation the last digit should increase from (1 -> 2 ->............9 -> 0).
4. Once the last digit reach number 0(Maximum), it will loop and increase first 2 digit like(AA -> AB ->...-> ZZ) simultaneously the middle part(3 digits '800' as per format) will increase each time the first 2 digit increases.
As an example - Username-- AA8001,Username:- AA8002,Username:-AA8003,Username:-AA8004--------Username:-AA8000
Next Sequence would be Username:- AB8011,Username:- AB8012------>Username:- AB8010 We also need information how we can store the existing table because at time of creation we need to check username for Uniqueness.
With Regards,
Siraj Molla
