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
Any help will be appreciated
Regards
Anser
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
B4X:
Dim dbSQL As SQL
Dim dbCursor As Cursor
dbCursor = dbSQL.ExecQuery("SELECT Col1, Col2 FROM MyTable")
dbCursor.Position = 11
B4X:
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 = 11Any help will be appreciated
Regards
Anser