pcsoft.us.windevCopyright 2026, PC SOFT10 Mar 2020 15:40:57 Z5 Mar 2020 02:57:50 ZI spent a whole day trying to find out a solution for this: Inside a string variable I have many insert SQL command separated by comma. It´s generated on-the-fly using data received using a Webservice. It´s a bulk load insert. Some errors can occur in this process like the I faced out today. A special caracter. It broked one of 400 SQL commands inside of my "SQL Buffer Commands". My code is : Procedure InsertSQLCommands(insCMD) SQLTransaction(sqlStart,MyCon) WHEN EXCEPTION IN IF HExecuteSQLQuery(dsExecDB,MyCon,hQueryWithoutCorrection,insCMD) THEN IF ErrorOccurred THEN Info(ErrorInfo(errFullDetails)) END SQLTransaction(sqlCommit,MyCon) RESULT True ELSE gLog.AddMessage("Falha Inserindo BulkLoad de Publicacoes", "ERRO") SQLTransaction(sqlRollBack,MyCon) fSaveText(".\inssql_Erro_" + SysDateTime() + ".sql",insCMD) RESULT False END DO gLog.AddMessage("Falha Inserindo BulkLoad de Publicacoes", "Excecao") SQLTransaction(sqlRollBack,MyCon) fSaveText(".\inssql_Exc_" + SysDateTime() + ".sql",insCMD) RESULT False END Questions: Why HExecuteSQLQuery doesnt´t return a false value when an error occurs? Transactions doesn´t work? Windev is good enougth to work with just and SQL commmand at a time ? Does some one can give some light about it?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67678-many-sql-commands-time-with-hexecutesqlquery/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)marco.a.machadopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67678-many-sql-commands-time-with-hexecutesqlquery-67684/read.awp10 Mar 2020 15:40:57 ZHi Sebastian My effords were for nothing. HExecuteSQLQuery just works fine using one SQL command at a time. I were using 40…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67678-many-sql-commands-time-with-hexecutesqlquery-67684/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67678-many-sql-commands-time-with-hexecutesqlquery-67684/read.awpMany SQL Commands at a time with HExecuteSQLQuerySebastian Arnoldpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67678-many-sql-commands-time-with-hexecutesqlquery-67682/read.awp9 Mar 2020 17:43:45 ZHi Marco, just two ideas. First, try to use HCancelDeclaration() and HFreeQuery() before your HexecuteSQLQuery() Secon…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67678-many-sql-commands-time-with-hexecutesqlquery-67682/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67678-many-sql-commands-time-with-hexecutesqlquery-67682/read.awpMany SQL Commands at a time with HExecuteSQLQuery