Android Question Do While loop on B4XTable

[JonnyCav]

I create a B4XTable from 3 sqlite tables and the table builds. (The table is static)

I created an array list from the table but I'm thinking that must be overkill.

All I want to do is simply INSERT INTO an sqlite table by looping through the table.

What would be the best method? We're only talking 200 records.

 

[JonnyCav]

I've solved the issue by simply replicating the database select and then performing an INSERT instead of putting it into a table. Simple solution, but as Erel often says in tutorials and videos, "if you replicate code then you're doing something wrong!"

So, even though I have found a workaround, the question still remains, 'Is there a better method?'

 

[Erel]

Sounds like a good solution.