Icon View Incident Report

Serious Serious
Reported By: Timon Christi
Reported On: 8/25/2010
For: Version 2.03 Build 20
# 3287 Adding Months to a DATE/TIMESTAMP Across Year Boundaries Causes Index/Range Check Error

We are using ElevateDB (Assembly Version in a .NET application with the ADO.Net provider. So far everything has worked great, but yesterday a customer reported a problem. I investigated and quickly found the cause: A statement contains a where condition which contains, among others lines the following expression:

V.MonatJahr>=(current_date() + (interval ''6'' month))

When I execute that statement directly in the ElevateDB manager, the statement runs fine. But when the statement is executed from within the program, an exception System.IndexOutOfRangeException occurs.

Resolution Resolution
Fixed Problem on 8/25/2010 in version 2.03 build 21

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