M maurizio barbera Member Licensed User Longtime User Jan 24, 2019 #1 Hello, I wanted to know if executing a query to insert / update / delete you can know if the query was successful or there were problems during the execution (eg: timeout, not connected, lost connect to server, ect ect) thank you
Hello, I wanted to know if executing a query to insert / update / delete you can know if the query was successful or there were problems during the execution (eg: timeout, not connected, lost connect to server, ect ect) thank you
Erel B4X founder Staff member Licensed User Longtime User Jan 24, 2019 #2 Are you using JdbcSQL? Upvote 0
M maurizio barbera Member Licensed User Longtime User Jan 24, 2019 #3 Erel said: Are you using JdbcSQL? Click to expand... I used library MSMySql v 1.09 + mysql-connector-java-5.1.34-bin.jar Upvote 0
Erel said: Are you using JdbcSQL? Click to expand... I used library MSMySql v 1.09 + mysql-connector-java-5.1.34-bin.jar
Erel B4X founder Staff member Licensed User Longtime User Jan 24, 2019 #4 You should use JdbcSQL with the async methods. Check the Success parameter. Upvote 0
M maurizio barbera Member Licensed User Longtime User Jan 24, 2019 #5 Erel said: You should use JdbcSQL with the async methods. Check the Success parameter. Click to expand... thanks, where i found example code?? Upvote 0
Erel said: You should use JdbcSQL with the async methods. Check the Success parameter. Click to expand... thanks, where i found example code??
DonManfred Expert Licensed User Longtime User Jan 24, 2019 #6 https://www.b4x.com/android/forum/t...ly-connect-to-remote-databases.84016/#content Upvote 0
M maurizio barbera Member Licensed User Longtime User Jan 24, 2019 #7 Thanks DonManfred, now study file into post. Last edited: Jan 24, 2019 Upvote 0
KMatle Expert Licensed User Longtime User Jan 24, 2019 #8 Search for "Insert ID" and "affected rows" in the MySQL documentation, too. Upvote 0