I'm struggling with trying to learn the proper way to use TIBTransaction. I've always used Delphi and DevArt components so this was always taken care of in the background. I have 3 buttons on a form... Run, Commit, Rollback. I run an SQL statement using the IBXScript parser. I'm following the IBX Script example. I'm trying to make an "Execute SQL Statement" window just like what is in FlameRobin, which has a "play" (F4) button, a "commit"
F5 button, and a "rollback" F8 button. I cannot make this work because once the transaction has been opened and commited or rollbacked ONCE, it never again fires the OnStartTransaction event nor the AfterTranscactionend event. What am I doing wrong? I need to have these two events fire reliably each time a transaction is started or ended.
I have attached a sample project. Click the "Help" link in the project for more explanation.
Platform: Lazarus 1.8.1, FPC 3.0.5, IBX 2.2.0