GetRows method problem

[exhumed]

Hi!
I have the question about GetRows method. I have following table:

column1 column2
abc 10
cde 20
fgh 30

the fragment of my code is:

Dim rs_temp1 As ADODB.Recordset
Set rs_temp1 = New ADODB.Recordset
rs_temp1.Open "Table1", CurrentProject.Connection, adOpenKeyset, adLockPessimistic
rs_temp1.Movefirst

Dim x
x = rs_temp1.GetRows(1, 0, 0)
MsgBox x(0, 0)

the result is "abc" and it is OK

If I change the row number just like:
x = rs_temp1.GetRows(1, 1, 0)
the result is this same as above, so "abc" instead of "cde"
Why it does not work correctly?


thx in advanced

[rpeare]

Can you explain what you are trying to do with this, are you trying to load information into an array or just cycle through your recordset one record at a time, or are you trying to access data from multiple rows at once?

If you're just trying to cycle through records you can do this:

Dim db As Database
Dim rst As Recordset

Set db = CurrentDb
Set rst = db.OpenRecordset("Table1")
rst.MoveFirst

Do While rst.EOF <> True
    x = rst.Fields(0)
    Debug.Print x
    rst.MoveNext
Loop

db.Close

EDIT when dealing with recordsets this way item 0 is actually the first column of data.

[exhumed]

THX a lot for the way you have shown me. It works
Of course I can explain: I learn how to use GetRows method, so I gave only one example from my deeds. I tried to do this with Do Until...Loop but using GetRows method result was three times "abc"

[rpeare]

I don't follow your response. I have never used the getrows method because I work with very large datasets and getrows is just not efficient enough for me. I was offering a solution that works depending on what the rest of your code is doing. That's all