I have a sql2005 db which holds data that I want to replicate on a sqlite db on the Android device. I have:
1) Coded the creation of the sqlite db on the device.
2) I can read data from the sql2005 db from the android device via HTML.
Now I am at lost on how to write the data I am reading from the main db into the sqlite tables.
The main problem is how to construct the sql statements. I've done it in the past but with Windows mobile devices and sqlce, the programs creates de db if necessary, it populates the device db with the data from the main db, it either synchronize both dbs or only send specific data changes from the mobile devices to the main db.
Please any help will be appreciated
1) Coded the creation of the sqlite db on the device.
2) I can read data from the sql2005 db from the android device via HTML.
Now I am at lost on how to write the data I am reading from the main db into the sqlite tables.
The main problem is how to construct the sql statements. I've done it in the past but with Windows mobile devices and sqlce, the programs creates de db if necessary, it populates the device db with the data from the main db, it either synchronize both dbs or only send specific data changes from the mobile devices to the main db.
Please any help will be appreciated
