B4J Question One ResultSet in several loops

[peacemaker]

Hi, All
Is it possible ?

If it needs to iterate the one ResultSet rows several times, 2-3 loops one by one - how to be?
If a ResultSet is passed as a parameter to a sub, and it's impossible to re-request SQL, but processing should make several passes along the set.

 

[Erel]

Not possible. Either make the query again or add the results to a list and pass the list.

 

[peacemaker]

If to create a "Cursor2" class that inherits Android's cursor class for B4J - might it help to simplify porting B4A code (that my old complex code) to B4J ?

 

[EnriqueGonzalez]

If to create a "Cursor2" class that inherits Android's cursor class for B4J -

Too complicated.

check dbutils method executememorytable, you will find easier to handle than cursors

 

[peacemaker]

Too complicated.

Hmm, not so tooo