query and business_day_forward

Hubertus

Hello

I have a query like

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

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

Gives me

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.