david13 Member Licensed User Oct 16, 2018 #1 Dear All, I have this problem and coul not find the appropriate solution: I have a table (20 lines) and want to save it in a remote database using my sql requests. the problem is because of the network connection the job sucess is false and so some lines are skiped and not sent to the remote server! Pleqse any help
Dear All, I have this problem and coul not find the appropriate solution: I have a table (20 lines) and want to save it in a remote database using my sql requests. the problem is because of the network connection the job sucess is false and so some lines are skiped and not sent to the remote server! Pleqse any help
DonManfred Expert Licensed User Longtime User Oct 16, 2018 #2 Why you are not using a Tractaction and send all comands in one call (send a batch of commands)? Upvote 0
david13 Member Licensed User Oct 16, 2018 #3 DonManfred said: Why you are not using a Tractaction and send all comands in one call (send a batch of commands)? Click to expand... Thanks For your answer, It's becase I never heard about it! I have this problem from a month ago, if you show me how I can do it, I will be so happy! Upvote 0
DonManfred said: Why you are not using a Tractaction and send all comands in one call (send a batch of commands)? Click to expand... Thanks For your answer, It's becase I never heard about it! I have this problem from a month ago, if you show me how I can do it, I will be so happy!
DonManfred Expert Licensed User Longtime User Oct 16, 2018 #4 Search the Forum! I´ll not do your work. Check the SQL Object Documentation. Check the Tutorial. I´m sure you´ll find infos about Transactions. Upvote 0
Search the Forum! I´ll not do your work. Check the SQL Object Documentation. Check the Tutorial. I´m sure you´ll find infos about Transactions.
Erel B4X founder Staff member Licensed User Longtime User Oct 17, 2018 #5 If you are using jRDC2 then each batch of commands is executed as a single transaction. Upvote 0