I am having a table with primary key as integer datatype and rest of the fields are ‘Decimal’ datatype with length (15,2). when i insert records it goes fine. While editing the record and posting with decimal values like 100.23 or 100.01 or 0.01 replacing the existing value also fine. Even when i edit the record and post the same record with decimals there is absolutely no problem.
But the problem is in real value i.e., 0.00, 100.00, 1000.00. when i insert record with 100.00 and posting it. and then edit the same record and post again with 100.00 then i have a problem. the error is thrown as ‘couldn’t perform the edit because another user changed the record’.
when i set the decimal field length with (20,2) then i get error in decimal value as well as in real value i.e., when i edit 100.23 with same 100.23 and post it i get error, and when i edit 100.00 with same 100.00 and post it i get error.
when i set the decimal field length with (15,2) or (12,2) i don’t get error in decimal values. only i get problem in real values.
ultimately my problem is when i edit 0.00 with 0.00 and post it i get error as ‘couldn’t perform the edit because another user changed the record’.
Kindly help me in this regard as soon as possible. since we need to edit and post always in the program with 0 value then we get always this error.
Please respond this query as soon as possible.