There is a portion of a MySQL database (no more than 500 records, 6 fields) that I would like to download into a local SQLite db every time a user signs in.
The reason I want to do this is because there are a lot of weird group by statements I want to chart, and I don't want to have to go back to the server over and over again.
So what I've done is created an empty local SQLite db that matches my MySQL table.
Is there a way to import all these records without having to do a "foreach" statement?
You will need to read the data into an ArrayCollection likely with HTTPService and then use a for loop to build and run the Insert ... Values() sql statements.
Preferably wrapped in transaction.