Dispaly Auto Incremnetd ID

Abdul Quddos

Hi Experts!

i need to give a unique id to a product on some user selections and display it to user, now i'm accomplishing it first go into db and get the max number, add one to this and finally display complete ID to the user. and now user select some other options and finally hit submit button and get record saved message.

Is it good way? i'm hitting database twice or more depends upon user's selection on changing.

Is there any best solution then plz feel free to suggest

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdul Quddos12y ago
in my scenario there is only one user! so i will't be problem for me! but as per your concurrency question yes it will cause problem that's why i'm here to take advice from experts
0
Jignesh Trivedi12y ago
ok
Are you think about the concurrent activity on this table?
I mean to say what happened when more the one user is requesting the max id of the table probably they all are get same max id....
0
Abdul Quddos12y ago
it is not incremented in database, it is just shown to user in incremented form
0
Jignesh Trivedi12y ago
hi,
I think, there is no other way to achieve this. but in you current logic what happen when user abort the current transaction? because your number is already increment before it shown to the user.
0
Abdul Quddos12y ago
Yes I'm Using sql server.

there are three categories each category has it's own credential to make unique key. let's say there are two categories A and B and one entry is going to be made against A the id of this category will be displayed to user like A1 and then user hit submit, in second insertion user will be displayed as A2 automatically. but when user enter record against B it would be showed to him as B1 for first time and B2 and B3 for second and third time respectively.
0
Sivaraman Dhamodaran12y ago
Use Auto Incremented Identity column (Are you using sql server :) )

The below link is useful:
Link
+1