pcsoft.us.windevCopyright 2026, PC SOFT20 Jan 2015 15:44:00 Z19 Jan 2015 19:03:00 ZHi, 1) Start a transaction, with HTransactionStart 2) write some code to do HAdd (or HModify) on some files 3) Now before Canceling (or commiting) the transaction - do a ProgramEnd (or just break the execution with the help of the debugger). Number (3) is just a common trick to emulate an unexpected application termination. It could be ANY abnormal termination .... Next time you go in the app, and try to run a query on the infected tables, you get an error saying you have a transaction that hasn't been canceled etc You cannot cancel the transaction with code and you CANNOT cancel it even in the HF control center. The only thing you can do is free the records to go on .....But the CC still shows this transaction in "transactions in progress". It does NOT happen when you use HF C/S v17. It happens when using HF C/S v 19 (both with WD17 and WD19 applications) HF C/S v17, takes care of these kind of abnormal terminations - inside a transaction. Just like the documentation says it does ... HF C/S v19 (latest) cannot handle this error anymore !!!!! Steven Sitas30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49938-major-bug-sql-v19/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49938-major-bug-sql-v19-49963/read.awp20 Jan 2015 15:44:00 ZHi Steven, We too ran into quite uninteresting problems with transactions. (Unfortunately, the Free Tech Support was not able…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49938-major-bug-sql-v19-49963/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49938-major-bug-sql-v19-49963/read.awpMAJOR BUG in HF SQL v19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49938-major-bug-sql-v19-49939/read.awp19 Jan 2015 19:16:00 ZForgot to say: The ONLY way to bypass this problem with HF SQL v19 is to RESTART HF SQL. Then your HTransactionInterrupted() w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49938-major-bug-sql-v19-49939/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49938-major-bug-sql-v19-49939/read.awpMAJOR BUG in HF SQL v19