Re: Which ADO object would you use to accomplish this?

When you want to insert, update, or delete a record from a database, which
ADO object would you use to accomplish this? (ADOCommand or ADORecordSet
or
ADODataReader or ADOUpdater)

This newsgroup discusses ADO (on-topic) _NOT_ ADO.NET (off-topic)

Having said that:

For just one record, one off, I would do a Connection Execute with SQL.
So

INSERT INTO yourtable VALUES (...)
UPDATE yourtable SET fld1 = ..., fld2 = ... WHERE whereclause
DELETE yourtable WHERE whereclause

If I had multiple records, it is a different story

Stephen Howe


.