Android Question RDC How to position/move to a particular record in DbResult

[Anser]

Friends,

Suppose I have 20 records in the DbResult (RDC), how do I position or move to a particular record directly by specifying the index?

OR

search and locate a particular value in the list of records and then position it.

Fo eg. Out of the 20 records, I want to go to the 11th record directly

in SQL we can position it as follows

Dim dbSQL As SQL
Dim dbCursor As Cursor
dbCursor = dbSQL.ExecQuery("SELECT Col1, Col2 FROM MyTable")
dbCursor.Position = 11

Dim result As DBResult = reqManager.HandleJob(Job)
' I know that I can know the total no of records as given below
result.Rows.size
' I am looking for something like
result.rows.position = 11

Any help will be appreciated

Regards
Anser

 

[Erel]

Dim row() As Object = result.rows.Get(10) 'get the 11th record

 

[Anser]

Thanks Erel.

Few Minutes back, I discovered it