Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

moving through records

ok what settings need to take place to just be able to move to next records using ado on the client side.It seems like the only way I can do it is to delete the current record and move to the next record but this I do not want to do I want to be able to move to the next record without deleting.
0
thenone
Asked:
thenone
  • 4
  • 2
1 Solution
 
jomacincCommented:
Dim oADO As ADODB.Recordset

' << Open Recordset Here >>

Do While Not oADO.EOF
  ' << do whatever you need with this record >>
  Call oADO.MoveNext
Loop
0
 
jomacincCommented:
The point there is the "MoveNext" method.
0
 
thenoneAuthor Commented:
I do that and it doesn't movenext exactly what you have written.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
jomacincCommented:
How are you opening the recordset then?
Sounds like a curser problem, can you post you code for just that?
0
 
thenoneAuthor Commented:
no its something else that is going on and I figured it out.Since I answered my own question can you answer another question.If I am showing all records in a set in maybe a label and I am not deleting them to count down.Ho can I show how many records that I have left to move thru.
0
 
jomacincCommented:
Use the "AbsolutePosition" property

[Number of Records Left] = oADO.RecordCount - oADO.AbsolutePosition
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now