Android Question Best way to send records from SQLite to Sql Server

infow

Member
Licensed User
Longtime User
Hi,

Im already using quite well the HttpJob2 to sync tables... or for now, getting data from tables in a remote server to SQLite.

Now Im trying to send data from SQLite to the SQL Server, but seems quite difficult send something like this in the poststring, jobdone method:

INSERT ORDER 1 -> GET THE ID OF THE RECORD IN SERVER
INSERT ITEM1 WITH THE ID RETRIEVED FROM THE ORDER 1
INSERT ITEM2 WITH THE ID RETRIEVED FROM THE ORDER 1
INSERT ITEM3 WITH THE ID RETRIEVED FROM THE ORDER 1
INSERT PAYMENT METHOD WITH THE ID RETRIEVED FROM THE ORDER 1

INSERT ORDER 2 -> GET THE ID OF THE RECORD IN SERVER
INSERT ITEM1 WITH THE ID RETRIEVED FROM THE ORDER 2
INSERT ITEM2 WITH THE ID RETRIEVED FROM THE ORDER 2
INSERT ITEM3 WITH THE ID RETRIEVED FROM THE ORDER 2
INSERT PAYMENT METHOD WITH THE ID RETRIEVED FROM THE ORDER 2

In async mode seems a complicated, there is a synced option for httpjob?

Thanks
 
I use:

INSERT ORDER 1
In JobDone
Get the ID of the record in server
IF ID <> 0 Then
Update SQLite database with the ID received
Start the transmission of ITEM1... ITEM3
In JobDone of each ITEM
Get the ID of the record in server and update SQLite database​
ENDIF​

Regards,

Edgar Ortiz
 
Upvote 0
Back
Top