same id no genrated when multiple user try to save the data
Posted: Fri Jul 10, 2009 4:38 am
Dear All
In my database there is a table having integer data type(not auto increment) when more than one user try to save the data then same id no is allotted for both .id no is generated by using the max(idno)+1 .to solve this issue i have used "lock tables tab_name write" but after using this when i try to populate the data from any other table then it returns 0.
is there any way to lock only one table so that other table could not be affect.
Regards-
Nierjesh
In my database there is a table having integer data type(not auto increment) when more than one user try to save the data then same id no is allotted for both .id no is generated by using the max(idno)+1 .to solve this issue i have used "lock tables tab_name write" but after using this when i try to populate the data from any other table then it returns 0.
is there any way to lock only one table so that other table could not be affect.
Regards-
Nierjesh