What I always wanted to know...

[Michael]

Hi there, I’ve developed a client server application where the user can post
transactions that contain workspace/begin/commit and may also have nested
transactions. On the main menu I would like to refresh certain data say every
10 minutes (user definable).

What I want to know is what exactly happens when the user posts a
transaction and in the middle of it the timer - that triggers the main menu
function – starts?

Is the transaction first posted and completed before the timer function
begins? Are both happening at the same time? What if I have several functions
that are triggered by different timers? Is each one first completed before
the next one starts?

Thanks to all of you who have taken the time to read this and perhaps
provides some feedback. This is very much appreciated.

Have a wonderful day…
Michael

 

[Mark A. Sam]

Are you talking about form timers?

It is my experience that if a process is running it will halt the timer
until it is competed. For example, I made a banner ad which changed the
images in unbound frames. If the timer was set to 30 second, it may take 40
seconds to recycle becuase the loading of the images delays the timer.

You can test this for yourself, by placing an unbound textbox on the form
and placing a message in it at certain parts of the code, like

Beep
[txtMessage] = "Transaction started"

'Code

Beep
[txtMessage] = "Transaction completed"

Time the interval manually. Then bypass the transaction and time it again.

Putting a message box will definately stop the timer, like:

MsgBox "Hi"
Beep
MsgBox "Ho"

If you are running timers in multiple forms, the timing between the forms
will not be synchronized. The first form will run its timer when it is
opened, the second when it is opened, etc. When the functions run will
depend on the progress of the particular timer independent of the other
forms.

God Bless,

Mark A. Sam