Icon View Incident Report

Minor Minor
Reported By: Brent
Reported On: 7/26/2004
For: Version 4.08 Build 1
# 1793 SQL TRUNC Function Causing AV When Not Using Optional TO Parameter

If I try and execute the following in DBSys I get "An error has occurred in the current SQL statement and the error message is:
Access Violation at address 001262D1 in module 'dbsys.exe'. Read of address 0000008."

select rcd_id, trunc(num/1000) num2 from company  where rcd_id < 10

select rcd_id, trunc(num/1000 TO 0) num2 from company  where rcd_id < 10

Comments Comments and Workarounds
The workaround is to use the TO parameter with a 0.

Resolution Resolution
Fixed Problem on 7/26/2004 in version 4.09 build 1