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

Harris

Expert
Licensed User
Longtime User
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

B4X founder
Staff member
Licensed User
Longtime User
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.
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…