not storing correct value in sql server from a vb.net application

[vsc33]

Hello,

I have a vb.net application that runs on a server. There are five client PC's that are connected to the server and all the data is saved on the server from my vb.net application.

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.

[nateraaaa]

Hello,

I have a vb.net application that runs on a server. There are five client PC's that are connected to the server and all the data is saved on the server from my vb.net application.

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.

Do you have validation on the text that can be entered in the text box to ensure that it is a valid integer that was entered? If not that is the 1st problem you must address.

Nathan

[vsc33]

Thanks Nathan for your reply.

Well we are validating the text box for integer.

And the mystery behind is that from that particular text box around 1000 entries are stored everyday in sql server over network. Out of these 1000 entries on an average only 5 to 7 entries are there where the data gets lost. And only for one particular field. Rest all the datas are stored correctly.