Make your own free website on Tripod.com

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