Hi,

I'm having some problems using functions in SQL.

I installed DBISAM 4.31 build 2 (32 bits) on a new machine (32 bits) with a fresh Delphi XE2 installation (32 bits).
It seems that everything is working as expected, except when I try to make a query that uses a function like this:

 SELECT * FROM table WHERE UPPER(field) = 'A'

I keep getting an access violation. If the UPPER function is removed it works fine.
Also if I use a constant in the function parameter like this, it also works fine:

 SELECT * FROM table WHERE UPPER('a') = 'A'

I have made a simple new project in Delphi (with just a DBISAMQuery and a simple query) and I'm still getting AV.
I'm accessing the tables locally (on the disk).

Is there any know issue with this build? Does someone have any idea that can help?

Thanks.

DBISAM 4.31 build 2 (32 bits)
Embarcadero® Delphi® XE2 Version 16.0.4276.44006 (Architect)
Windows 7 Pro (32 bits)

Pedro,

<< I installed DBISAM 4.31 build 2 (32 bits) on a new machine (32 bits) with
a fresh Delphi XE2 installation (32 bits). It seems that everything is
working as expected, except when I try to make a query that uses a function
like this: >>

You're most likely seeing this problem:

http://www.elevatesoft.com/incident?action=viewrep&category=dbisam&release=4.31&incident=3515

--
Tim Young
Elevate Software
www.elevatesoft.com