pcsoft.us.windevCopyright 2026, PC SOFT29 Jul 2015 17:10:13 Z29 Jul 2015 14:30:00 ZThis problem only occured in batch script . for example , i made typo when i suppose to insert into tableA , i type tableB which is not exist. ------------------------------------------------------------ example 1 M_sql is string = [ delete from tableA where col1 = 1 ; insert into tableB (col1, col2) values (1, 'BBB'); SELECT ROW_COUNT() ; ] IF SQLExec(M_sql, M_QRY) = False THEN SQLInfo() Info("Error SQLExec " , SQL.MesError) END ----------------------------------------------------------------------- example 2 M_sql is string = [ insert into tableB (col1, col2) values (1, 'BBB'); SELECT ROW_COUNT() ; ] IF SQLExec(M_sql, M_QRY) = False THEN SQLInfo() Info("Error SQLExec " , SQL.MesError) END ======================================================== if tableB is not exist example1 , SQLExec() will still return true while example2 , SQLExec () will return false. how come? this is because SQLExec() return true/false of execution of the first script in the batch which in example1 is "delete from tableA where col1 = 1 ;" Solution? if you really need to run batch script , the solution is to create stored procedure .30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53317-wm20-android-mysql-bug-sqlexec-with-webservice/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Willian Fernandopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53317-wm20-android-mysql-bug-sqlexec-with-webservice-53321/read.awp29 Jul 2015 17:10:13 ZHello ccc2. it would be nice if you had a name .... First I suggest that you run a sentence at a time, do not place all in on…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53317-wm20-android-mysql-bug-sqlexec-with-webservice-53321/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53317-wm20-android-mysql-bug-sqlexec-with-webservice-53321/read.awp[WM20 (android - Mysql)] Bug in SQLExec() with webservice