pcsoft.us.windevCopyright 2026, PC SOFT16 Feb 2016 11:57:00 Z15 Feb 2016 17:27:00 ZHi, in my application I use queries created by WD Query Editor by HExecuteQuery, queries written in MySQL code by HExecuteSQLQuery and the functions HTransactionStart, HTransactionEnd and HTransactionCancel. The application has many components using these queries and sharing an external variable (ExtDBConnection) to make sure to use the same connection...but it is not enough, in the MySQL log I see many connections opened by the app. Do someone of you have a technique? Dann30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56448/read.awp16 Feb 2016 11:57:00 ZI found issues with HTransactionxxx functions in that it left open connections on MySQL. The help says to use HTransactionStart…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56448/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56448/read.awp[WD20] How to make me sure to use the same DB connection?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56446/read.awp16 Feb 2016 08:58:00 ZHi DerekT, The online Help teaches that HTransactionStart, HTransactionEnd and HTransactionCancel work with the Native Access…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56446/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56446/read.awp[WD20] How to make me sure to use the same DB connection?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56443/read.awp15 Feb 2016 20:48:00 ZHTransactionStart, HTransactionEnd and HTransactionCancel do not work with MySQL You need to use something like//Open connect…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56443/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56443/read.awp[WD20] How to make me sure to use the same DB connection?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56442/read.awp15 Feb 2016 18:01:00 ZThe same for me. The main exe opens the connection "MyConnection" with HOpenConnection + HChangeConnection for all tables (*.* p…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56442/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56441-wd20-how-make-sure-use-same-connection-56442/read.awp[WD20] How to make me sure to use the same DB connection?