B4J Question B4J - SQLite - MoveNext - MovePrevious - Position

[AlpVir]

In B4J (if I am not mistaken) there are no instructions SQLite comparable to MoveNext or MovePrevious environment Microsoft ADO.
In SQLite B4A exists the instruction Position that is able to compensate in part to this lack.
I confirmed in my favor this impression?
And possibly things you could remedy this lack ?
Thanks for the attention

 

[rboeck]

Look for Resultset and Nextrow; i think, its comparable to and ADO forwardonly resultset.

 

[EnriqueGonzalez]

you could use ExecuteMemoryTable from the dbutils class

it returns a list with a map for every Row where the Keys are the column names so you only need to play with index of the list and call the map for the information of every row.

 

[Erel]

I agree with @Enrique Gonzalez R. Use DBUtils.ExecuteMemoryTable.

 

[AlpVir]

@Enrique Gonzalez R
Great suggestion. I applied very quickly and fully meets my needs. Thank you !