When I run an Action Query, I would like to replace the default "Run Query XXX__________" in the Status Bar with a message similar to when I use the Process Meter in an iterative loop, for instance:
SysCmd(acSysCmdInitMeter, "Updating Records", intRecCount)
which gives me "Updating Records XXX__________" in the Status Bar.
I am using 3 queries:
And I would like to have a distinct message appear in the Status Bar for each Query.
These are huge batch updates (up to 350,000 records), so I can't do it in code, and the processor gets pegged, so the system knots up so badly that the screen doesn't refresh but every 4 or 5 minutes. I got the whole process to finish in 35 minutes, but the 3 Queries all report "Run Query XXX__________" in the Status Bar, and I would like to show which query is running.