Checking record values in a timer loop

nismo2006

Hey,

I am trying to communicate between two processes to determine when one should run and the other should wait. I have a new table that indicates if one of the processes is running (by a boolean value). The other process should wait until a boolean field in this table is false. I have a timer that will continually poll the table and check to see if the value is false. It is not picking up on the value though. It continually thinks that it is true and never allows for it to run. I have tried to put the check into a function and a codeunit but no luck. It is almost like it is grabbing the record and holding the value. I have also tried to make another variable that is that table and it still does not do it. Has anyone come across this situation and I appreciate the help in advance.

Thanks

ara3n

how does your code look like that does the checking?
Are you clearing the variable record before using it?

kine

You can try to use SELECTLATESTVERSION before you get the record from the DB.

nismo2006

I will try both of these methods, I appreciate the help. I was just a little confused that it seems like even though I call a new variable instance of the table, it keeps its values. It is almost like it has kept its cached values and can't be reset. I will post my results and thanks again.

nismo2006

Kine,

It worked brilliantly!!! Thank you so much for your help and hope you have a good day.

kine

You are welcome! 8)