To add a record, two sql runs under Commit transaction. One runs an insert statement while the other updates a record.
However, I have noticed a error. The update statement has lot of other fields which are stored correctly, but sometimes (say one out of 100 record) it doesnt stores the correct value to a numeric field. This field is integer and the data is stored from a text box.
This is creating a lot of trouble in my application. Please help.