Can I call movenext on a recordset with a single new row in it?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I open a recordset into a table that may or may not return rows. If it does
not return a row, I .AddNew one. This repeats as required. For instance, if
the recordset had two rows and I'm adding four, it should re-use the first
two and then .AddNew two new ones.

Is it OK to .MoveNext on a newly created row? It seems to work OK, but I
just want to make sure there's no edge cases?

Maury
 
As long as rs.EOF isn't true, you should be able to use .MoveNext without
issue.
 

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

How to use recordset to update data in table? 2
Issue with Movenext statement 2
A theoretical question: how best to manage perpetual recordset needs? 25
Typing into a field bound to a locked recordset 11
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
MoveLast on TableDef Recordset 5
Final .MoveNext in recordset is very slow 10
Can't call .update more than once? 3

Back
Top