makis_best Well-Known Member Licensed User Longtime User Mar 1, 2022 #1 Hi I am sending from my Android app some records to a MSSQL Server. Is there any way to verify that these records "reach" MSSQL Server? Thank you
Hi I am sending from my Android app some records to a MSSQL Server. Is there any way to verify that these records "reach" MSSQL Server? Thank you
Solution Erel Mar 3, 2022 There is no such thing. Assuming that you are sending a batch request, all commands are executed with a single transaction. This means that either they all succeed (and Job.Success = True) or they all fail.
There is no such thing. Assuming that you are sending a batch request, all commands are executed with a single transaction. This means that either they all succeed (and Job.Success = True) or they all fail.
Erel B4X founder Staff member Licensed User Longtime User Mar 2, 2022 #2 I'm not 100% sure what you mean with "verify". If Job.Success is true then the server responded successfully. Upvote 0
I'm not 100% sure what you mean with "verify". If Job.Success is true then the server responded successfully.
makis_best Well-Known Member Licensed User Longtime User Mar 2, 2022 #3 Erel said: I'm not 100% sure what you mean with "verify". If Job.Success is true then the server responded successfully. Click to expand... I have this case. Let say that I want to transfer 10 records to MSSQL Server. Job.Success return true as you say but with a simple select I find out like that only 8 records inserted on SQL table. Upvote 0
Erel said: I'm not 100% sure what you mean with "verify". If Job.Success is true then the server responded successfully. Click to expand... I have this case. Let say that I want to transfer 10 records to MSSQL Server. Job.Success return true as you say but with a simple select I find out like that only 8 records inserted on SQL table.
Erel B4X founder Staff member Licensed User Longtime User Mar 3, 2022 #4 There is no such thing. Assuming that you are sending a batch request, all commands are executed with a single transaction. This means that either they all succeed (and Job.Success = True) or they all fail. Upvote 0 Solution
There is no such thing. Assuming that you are sending a batch request, all commands are executed with a single transaction. This means that either they all succeed (and Job.Success = True) or they all fail.
