My table is Beneficiary(benid ,Name) in which benid is primary key.
suppose in our table records are
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.