pcsoft.us.windevCopyright 2026, PC SOFT22 Jan 2015 23:05:00 Z19 Jan 2015 15:06:00 ZHi, I am testing an HF SQL (v19) application, that uses transactions. As soon as I start the transaction and do a couple of adds, I stop the application (from the debugger/WD). So of course my transaction is now CORRUPTED. Here is my code for starting the transaction: HFTransaction() // ->this is HF SQL /// do adding IF tr=false HTransactionCancel() ELSE HTransactionEnd() END So at the beginning of my code I have code to catch an interrupted transaction: If HTransactionInterrupted(myconnectin)=true HTransactionCancel(etc...) END The problem is that HTransactionInterrupted is NEVER true, although I have a corrupted transaction. I know it because as soon as I do a query, I get a report for an interrupted transaction from WD19. I tried to run HTransactionCancel, without checking HTransactionInterrupted and it doesn't cancel the transaction ... The only way to do it, is go to the Control Center and do it Manually ... Everything works as expected with HF Classic Any Ideas?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50018/read.awp22 Jan 2015 23:05:00 ZHi Steven, keep us informed please. It's a major bug and I hope they fix that in WX20.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50018/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50018/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50015/read.awp22 Jan 2015 20:39:00 ZHi Steven, Thank is good new. I'll ask to be informed about that ref. Thank you very much. :spos: Alexandre Leclerchttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50015/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50015/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50014/read.awp22 Jan 2015 18:18:00 ZHi Alexandre, just got an email from PCSoft that they can now reproduce the problem. Incident reference #90 886/258632 - forwa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50014/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-50014/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49992/read.awp21 Jan 2015 21:59:00 ZHi Steven, Now this is great news! I wish for you that they can reproduce and find the source of the problem. I'll subscribe …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49992/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49992/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49989/read.awp21 Jan 2015 20:33:00 ZHi Alexandre, I have finally made a very SIMPLE WD application - with 1 file and 10 lines of code - that ALWAYS shows the pro…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49989/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49989/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49978/read.awp20 Jan 2015 21:16:00 ZHi Steven, Indeed, this will convert all "in transaction" records as normal records. So yes, this is the "panic button" solut…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49978/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49978/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49977/read.awp20 Jan 2015 20:50:00 ZHi Alexandre, I haven't used HTransactionFree in my code, but I did use it from the HFSQL CC. Double Clicked a file ->Transact…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49977/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49977/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49976/read.awp20 Jan 2015 20:15:00 ZHi Steven, Have you tried HTransactionFree()? It did the thing all the time for me, in the same exact context: transactions w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49976/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49976/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49975/read.awp20 Jan 2015 20:10:00 ZHi Alexandre and Derek, the code Derek posted, will NOT help in this situation - I have tried it with NO luck. The user/ap…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49975/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49975/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49973/read.awp20 Jan 2015 17:25:00 ZHi DerekT, Nice little code. I think I'll implement it in the C/S mode of my application. It might be just what I need for th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49973/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49973/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49969/read.awp20 Jan 2015 16:05:00 ZSteven I run the following procedure called from the project initialisation. Not had any issues during the last 2 years or s…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49969/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49969/read.awpHtransactionCancel, WD 19guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49964/read.awp20 Jan 2015 15:48:00 ZHi Steven, It might not be of help, but HTransactionCancel() uses the local users' transaction file. If this file is lost, yo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49964/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49933-htransactioncancel-49964/read.awpHtransactionCancel, WD 19