ADO question

D

Dorian

If I am writing to a recordset with ADO and I have done a rs.Addnew and then
do not want to write the record, do I just not do an rs.Update or do I have
to do something to flush the pending record before I do another rs.Addnew.
Currently, I just omit the rs.Update but I am still getting the records
added to my output table.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
K

KC-Mass

Don't do a rs.Update until you have tested/validated the data and know you
want to add it.
Even if you don't do an update you've added the record but without values
 
K

KC-Mass

Don't do a rs.Update until you have tested/validated the data and know you
want to add it.
Even if you don't do an update you've added the record but without values
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset processing problem 2
ADO Access For Value List Error 4
Table of Contents font ? 1
Me.NewRecord and Me.Dirty 5
Docmd.Applyfilter 1
WHY use bookmarks? 3
Effect of Applyfilter 1
Encrypt column? 2

Top