query and business_day_forward

[Hubertus]

Hello

I have a query like

Code: Select all

FIND Bestelldetail WHERE Bestelldetail.Bestellung.Datum>DATE_ADD(CURRENT_DATE,2) ORDER BY Bestelldetail._Tour,Bestelldetail._Kunde,Bestelldetail._Produkt

that works fine.

But using BUSINESS_DAY_FORWARD instead of DATE_ADD like in

Code: Select all

FIND Bestelldetail WHERE Bestelldetail.Bestellung.Datum=BUSINESS_DAY_FORWARD(CURRENT_DATE,1) ORDER BY Bestelldetail._Tour,Bestelldetail._Kunde,Bestelldetail._Produkt

Gives me

Code: Select all

Internal error. Element BUSINESS_DAY_FORWARD in query condition Bestelldetail.Bestellung.Datum=BUSINESS_DAY_FORWARD(CURRENT_DATE,1) of query FIND Bestelldetail WHERE Bestelldetail.Bestellung.Datum=BUSINESS_DAY_FORWARD(CURRENT_DATE,1) ORDER BY Bestelldetail._Tour,Bestelldetail._Kunde,Bestelldetail._Produkt cannot be converted to the currently installed version of SQL

This happens on Aware IM build 882 running against MySQL 4.1.12 both on Ubuntu Server but different machines.

Hubertus

[aware_support]

BUSINESS_DAY_FORWARD and BACKWARD functions are currently not supported if used in queries for all databases except Derby. This is a limitation.