Reported By: Roy Lambert Reported On: 9/4/2009 For: Version 2.02 Build 15
# 3066INTERVAL 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 and WorkaroundsThe correct way to specify an INTERVAL is in single-quotes ('3'), just like a DATE, TIME, or TIMESTAMP constant.
ResolutionFixed Problem on 9/5/2009 in version 2.03 build 1
Products AffectedElevateDB 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