A
anasser
I have in my Database a status window form that is called from the code
and displays the is happening in the background like(when connecting to
the SQL Server and uploading/downloading data, the Status Window will
tell the user which table is currently being worked).
I need to add to this Status Window a Timer (or a Progress Bar) that
will not freeze when a long query is running. This will give the user
a feeling of that his/her database is doing something not just frozen.
I can create a Progress Bar for when the Database is executing a loop
but I do not know how to do it for when the program is executing a
query that takes like 5 minutes.
I do not want to use the SysCmd(acSysCmdSetStatus,...) bar that is at
the bottom of the form instead I would like to have all the messages to
the user broadcasted through this Status Window.
Thanks, and please give me your thoughts and ideas and if possible
sample code.
and displays the is happening in the background like(when connecting to
the SQL Server and uploading/downloading data, the Status Window will
tell the user which table is currently being worked).
I need to add to this Status Window a Timer (or a Progress Bar) that
will not freeze when a long query is running. This will give the user
a feeling of that his/her database is doing something not just frozen.
I can create a Progress Bar for when the Database is executing a loop
but I do not know how to do it for when the program is executing a
query that takes like 5 minutes.
I do not want to use the SysCmd(acSysCmdSetStatus,...) bar that is at
the bottom of the form instead I would like to have all the messages to
the user broadcasted through this Status Window.
Thanks, and please give me your thoughts and ideas and if possible
sample code.