>My colleague (tester) told me she reproduced the same problem locally with 30 minute lessons. The incentive of less than .5 is still firing for them.
>
>This doesn't make much sense since the SET DECIMALS is not changed in the application and it's default VFP value.
>
>I am going to try to play with it later myself in debugging mode.
It may be that the fractional seconds portion of the VFP datetime values is not exactly .000, even though it (nominally) is in SQL Server. In that case, as you've already found you can ROUND( ) to a reasonable number of decimals, or use a fixed tolerance e.g.
IF End_Time - Start_Time > 1799.5
IF ( End_Time - Start_Time ) / 3600 > 0.5
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up