View Incident Report

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

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

Comments and Workarounds

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

Resolution

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap