Android Question RDC: How to check that record(s) were inserted?

[Harris]

Now that I have ExecuteBatch working, how do I ensure that each record in the batch was inserted in the table? I wish to update my local (SQLite) table field (LogSent) to equal 1 when posted successfully on the server.

Perhaps I should use ExecuteCommand instead (in a loop for each record - even thou slower)?

 

[Erel]

ExecuteBatch creates a single transaction. If Job.Success is true then all the statements were executed successfully. If not then the transaction is rolled back.

Perhaps I should use ExecuteCommand instead (in a loop for each record - even thou slower)?

Much better to use ExecuteBatch.