Icon View Incident Report

Serious Serious
Reported By: Steve Forbes
Reported On: 2/27/2007
For: Version 1.00 Build 1
# 2245 Subtracting Two TimeStamp Values Results in an Incorrect Value

When I run the following SQL, the result is that all values are large negative values (e.g.-913228448) indicating a numeric overflow perhaps.

SELECT (FinishTime - StartTime) AS Duration FROM Calculated;



Resolution Resolution
Fixed Problem on 3/1/2007 in version 1.01 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image