updating

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

Bill H.

I want to loop through a recordset, and update one field at the then-current
record to a new value.
how to do?

thx.
 
Bill said:
I want to loop through a recordset, and update one field at the
then-current record to a new value.
how to do?

thx.
Click to expand...

Any reason you don't just use an Update Query? Performing updates by
looping a recordset is a LOT slower than a query in almost all cases.
 
I did find a solution, but the reason was that I needed to update a field to
a different value for each record depending on some other criteria (like the
new value would contain a random number), and I couldnt' come up with a
query that would let me do that.
 
You must log in or register to reply here.

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

stuck in a loop 5
Return to the front of a loop. 2
Loop through ADO recordset, update records, and count updated reco 1
ADO Recordset 5
Jump to specific record in recordset 1
Recordset automatically updates 1
Utilizing Recordset field in vb Requery Command Verbiage 1
Loop through recordset with a twist 2

Back
Top