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)?
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)?