could not update, currently locked
-
With Adodc3.Recordset .MoveFirst Do While Not .EOF cPrice = DataGrid1.Columns("Price") strProductCode = DataGrid1.Columns("ProductCode") 'updating the price table Dim updateSQL As String updateSQL = "Update Price set Price = " & cPrice & " " & _ " where PriceCode = '" & strPriceCode & "' " & _ " AND ProductCode = '" & strProductCode & "'" Set RS = Conn.Execute(updateSQL) .MoveNext Loop End With the above is code i use to update a datagrid, the only column that is not locked in the datagrid is the price column and the only other piece of code that i think may affect it is a BeforeColUpdate function checking to see only numeric values are entered...is there anything i am doing wrong? it updates the prices fine in the database, is there any way i could catch it to degrade gracefully instead of crashing out? Thanks in advance!