Ado

[jojomannoh]

Does Any One Know The Code For The 'move' Method Of Ado Invb6

[shuvo2k6]

Does Any One Know The Code For The 'move' Method Of Ado Invb6

Is this that what mention here

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

Regards,
shuvo2k6

[debasisdas]

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.

[QVeen72]

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

[Ali Rizwan]

Does Any One Know The Code For The 'move' Method Of Ado Invb6

For ADODC use these commands :

To navigate

With ADODC1.Recordset

.MoveNext
.MovePrevious
.MoveLast
.MoveFirst

EndWith

For ADODB use these commands :

To navigate

With REC

.MoveNext
.MovePrevious
.MoveLast
.MoveFirst

EndWith

But in this case u need to define ADODB connection and its Recordset (REC in example).

Dim DATA As New ADODB.Connection ' Defining Connection
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 <<