My table is Beneficiary(benid ,Name) in which benid is primary key.
suppose in our table records are
benid Name
1 mohan
2 shyam
3 radhe
if n number of user insert the record simultaneously. with retrieve max (benid )+1
than benid 4 will for all users
so only one user can insert
than there is error benid already exists for users.
how we resolved it.
Niranjan Pandey