AlpVir Well-Known Member Licensed User Longtime User Aug 5, 2015 #1 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
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
R rboeck Well-Known Member Licensed User Longtime User Aug 5, 2015 #2 Look for Resultset and Nextrow; i think, its comparable to and ADO forwardonly resultset. Upvote 0
EnriqueGonzalez Expert Licensed User Longtime User Aug 5, 2015 #3 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. Upvote 0
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 B4X founder Staff member Licensed User Longtime User Aug 6, 2015 #4 I agree with @Enrique Gonzalez R. Use DBUtils.ExecuteMemoryTable. Upvote 0
AlpVir Well-Known Member Licensed User Longtime User Aug 6, 2015 #5 @Enrique Gonzalez R Great suggestion. I applied very quickly and fully meets my needs. Thank you ! Upvote 0
