4Site
Support Request System
View Patch #50.014.019
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
01902 -
Numeric Comparison in mkScript, FSUpdate
Symptoms:
Numeric Comparison in mkScript, FSUpdate requires an approximately equal comparison rather than an exactly equal because it is comapring two floating point values. As a result, a test to see if a column length had changed was skipped in error.
Solution:
Numeric comparisons involving floating-point values are dangerous as floating-point values are not exact when represented at the machine level. I changed the comparison to only CDbl() the operands when they are actually floating-point(numeric AND contains a '.') and to use a the significant digit comparison from http://support.microsoft.com/kb/69333. Numeric values that are not floating-point(contain '.') are CLng()'d instead of CDbl()'d and do not suffer accuracy issues when compared.
Browse Patches
Find a Patch
Return to Request System Menu
