Icon View Incident Report

Minor Minor
Reported By: Roy Lambert
Reported On: 9/4/2009
For: Version 2.02 Build 15
# 3066 INTERVAL Constants Can Be Specified as Integer Constants When They Should Be In Quotes

The following SQL works when it should cause a compilation error.

select * from diary where
_day - interval 3 DAY > CURRENT_DATE

Comments Comments and Workarounds
The correct way to specify an INTERVAL is in single-quotes ('3'), just like a DATE, TIME, or TIMESTAMP constant.

Resolution Resolution
Fixed Problem on 9/5/2009 in version 2.03 build 1

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