ericdbyrd
01-14-2023, 12:32 AM
So I'm having a problem with a Do-Until Loop.
As you know, when the test condition goes True, execution jumps out of the Loop, instead of continuing to loop around inside.
I had a situation in which the test condition went True, but execution continued to loop around inside, instead of jumping out. Of course this clustered up my entire results.
The test condition compared two variables, both declared as Double. They were time values, and I always declare time variables as Double, to help prevent rounding errors.
So when the two time values were equal, the test condition should have gone True, and the Loop should have ended. The two variables both had a value of exactly .54375, which is equivalent to 1:03:00 pm. Because there are only 5 digits in the mantissa, it's hard to imagine this was caused by a rounding error... my best guess is, it's some kind of Excel checksum thing.
Ultimately I used the Editor to put execution on the next statement, and finished the run that way.
This program has been run hundreds of times, and this is the first time this has happened. I've never before seen a Test condition go True in a Do-Until Loop, without execution jumping out like it should.
As you know, when the test condition goes True, execution jumps out of the Loop, instead of continuing to loop around inside.
I had a situation in which the test condition went True, but execution continued to loop around inside, instead of jumping out. Of course this clustered up my entire results.
The test condition compared two variables, both declared as Double. They were time values, and I always declare time variables as Double, to help prevent rounding errors.
So when the two time values were equal, the test condition should have gone True, and the Loop should have ended. The two variables both had a value of exactly .54375, which is equivalent to 1:03:00 pm. Because there are only 5 digits in the mantissa, it's hard to imagine this was caused by a rounding error... my best guess is, it's some kind of Excel checksum thing.
Ultimately I used the Editor to put execution on the next statement, and finished the run that way.
This program has been run hundreds of times, and this is the first time this has happened. I've never before seen a Test condition go True in a Do-Until Loop, without execution jumping out like it should.