EDITING RECORDS

With ADO, the following are still functional. Therefore, if you wish, you may edit records with something similar to the following:

Private Sub cmdEdit_Click()

ReadFieldsKirbyStock

rs.Update

End Sub

Public Sub ReadFieldsKirbyStock()

rs.Fields("StockID") = txtStockID.Text

rs.Fields("UnitPrice") = txtUnitPrice.Text

rs.Fields("OnHand") = txtOnHand.Text

rs.Fields("Reorder") = txtReorder.Text

rs.Fields("Description") = txtDescription.Text

End Sub

However, for the purposes of this application, rather than using the RS.Edit, reading the fields and subsequently issuing an RS.Update (Above), we will use Oracle Stored Procedures (See Editing Records under SQL PLUS: Creating Oracle Stored Procedures) to centralize processing at the Server level. This will keep network traffic to a minimum.

RETURN TO HOME PAGE