select * from diary where
_day - CAST(:day AS INTERVAL DAY) > CURRENT_DATE

---

 Comments

---

The problem is that ElevateDB cannot figure out the correct paramater type just from the usage of the parameter. ElevateDB now checks for an unknown data type for a parameter and uses the data type assigned by the user/developer for the parameter in such cases.

---

 Resolution

---

Fixed Problem on 9/6/2009 in version 2.03 build 1

---

 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