CancelUpdate - method of the AdoRecordset object
It is used for ending the edit mode and cancelling
all modifications to the current record. The edit mode was started by the AddNew
method (in this case the new record is cancelled) or by writing the values into the current record (record edit).
Adds a new record into the table ("table1"
) and modifying the contents of the new record, by using the stored AdoRecordset
), in the PmaAdo
), that is already connected to the database (see the DbOpen
method), by the SQL
query ("SELECT * FROM table1"
). At the end, the adding of a new record is not confirmed by the Update
method, but cancelled by the CancelUpdate
var oDb = pMe.Pm("/TestAdoDb");
var oRs = oDb.RsOpen("table1", "SELECT * FROM table1", "cursor:static;lock:optimistic;");
oRs.Fields.Item("name").Value = "pi";
oRs.Fields.Item("value").Value = 3.14;