pcsoft.us.windevCopyright 2026, PC SOFT15 Jan 2016 11:13:00 Z14 Jan 2016 11:31:00 ZHello, In a WD 19 application I have a LONG running transaction. When I do a HExecuteQuery(query) on a query that has data modified by the transaction, I get a fatal error. Is this NORMAL behaviour ? I would think that the query would go on, using the data prior to the transaction. I know that I should NOT use LONG LONG running transactions, but this is done just to emulate a heavy user environment .... Steven Sitas30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55880/read.awp15 Jan 2016 11:13:00 ZHi Joris, You are right, transactions should be as short as possible ... The code (looping through an inventory file in a tran…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55880/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55880/read.awpHExecuteQuery and Transactionsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55879/read.awp15 Jan 2016 09:11:00 ZHi Steven, Personally I doubt if it is a good idea to loop trough your article file in a transaction. If you have a huge art…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55879/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55879/read.awpHExecuteQuery and Transactionsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55877/read.awp14 Jan 2016 19:23:00 ZHi, After doing some tests, it seems like WD20 doesn't have this problem anymore !!! Also - although my testing here is limite…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55877/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55877/read.awpHExecuteQuery and Transactionsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55875/read.awp14 Jan 2016 16:40:00 ZAlexandre, here is a simple situation that shows the problem (1). Only 1 file, say an Inventory file. I loop through the in…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55875/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55875/read.awpHExecuteQuery and Transactionsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55874/read.awp14 Jan 2016 15:51:00 ZHi Steven, Maybe the "transaction isolation level" doc might help you, since that has been modified in V19: http://doc.windev…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55874/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55874/read.awpHExecuteQuery and Transactionsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55873/read.awp14 Jan 2016 15:32:00 ZHi Alexandre, This section talks about INSERT/UPDATE queries. My queries are just simple queries on C/S. The same problem i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55873/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55873/read.awpHExecuteQuery and Transactionsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55872/read.awp14 Jan 2016 15:08:00 ZHi Steven, There is a hole in my experimental knowledge here. But 3 questions: 1. Is it possible that HTransaction...() not …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55872/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55872/read.awpHExecuteQuery and Transactionsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55867/read.awp14 Jan 2016 14:34:00 ZHi Alexandre, I tried "hWithTransaction" but NO luck. I am going to setup WD20 and HFSQL 20 and see if this is just a v19 prob…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55867/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55867/read.awpHExecuteQuery and Transactionsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55859/read.awp14 Jan 2016 14:16:00 ZHi Steven, Have you added the "hWithTransaction" constant when calling HExecuteQuery()? Kind regards, Alexandre Leclerchttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55859/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55856-hexecutequery-and-transactions-55859/read.awpHExecuteQuery and Transactions