Processing MySQL query shown on progress bar

Question

I have form that passes about 37 values to MS Access base with INSERT or UPDATE query. Actually it happens very fast so my wish to indicate this process on progress bar is just a fancy feature. How can I bind mysql query execution to progress bar filling? Or should I just emulate this relativity?

Answer 1

If you are using a DBExpress TSQLconnection, it has a property ActiveStatements

So if you add a timer that fires every N seconds, when it fires check the ActiveStatements property and update your status accordingly.

Update: As correctly pointed out by Rob Kennedy in the comments, ActiveStatements does not show insert or update statements so it will not work for what you want.

TADOConnecttion does however have the OnWillExecute and OnExecuteComplete events that fire before or after a command is executed, so it may be possible to do something with them, I just tested it and they do work on update statements.