By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Ado

P: 1
Does Any One Know The Code For The 'move' Method Of Ado Invb6
Jan 30 '08 #1
Share this Question
Share on Google+
4 Replies


P: 68
Does Any One Know The Code For The 'move' Method Of Ado Invb6
Is this that what mention here

Adodc1.Recordset.Move (1), this move the data by 1 row.

Regards,
shuvo2k6
Jan 31 '08 #2

debasisdas
Expert 5K+
P: 8,127
open the connection
open the recordset

Then use any of the four MOVE mthods of recordset object to move back and forth.

Dont forget to check for BOF and EOF before moving.
Jan 31 '08 #3

QVeen72
Expert 100+
P: 1,445
Hi,

.MoveFirst
.MoveNext
.MovePrevious
.MoveLast
are Self Explainatory.

.Move 3 Moves to the 3rd record from current position.
If you want to move to 8th rec from beginning, then you will have to move first and then 8:
RST.MoveFirst
RST.Move 8

Regards
Veena
Jan 31 '08 #4

Ali Rizwan
100+
P: 927
Does Any One Know The Code For The 'move' Method Of Ado Invb6
For ADODC use these commands :

To navigate

Expand|Select|Wrap|Line Numbers
  1. With ADODC1.Recordset
  2.  
  3. .MoveNext
  4. .MovePrevious
  5. .MoveLast
  6. .MoveFirst
  7.  
  8. EndWith
For ADODB use these commands :

To navigate

Expand|Select|Wrap|Line Numbers
  1. With REC
  2.  
  3. .MoveNext
  4. .MovePrevious
  5. .MoveLast
  6. .MoveFirst
  7.  
  8. EndWith
But in this case u need to define ADODB connection and its Recordset (REC in example).

Expand|Select|Wrap|Line Numbers
  1. Dim DATA As New ADODB.Connection ' Defining Connection
  2. Dim REC As New ADODB.Recordset    ' Defining Recordset
For more help you can contact me through Yahoo or you can PM me.
You can find my email address from my profile (By clicking my avatar or name).

Regards
>> ALI <<
Feb 7 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.