In the ADO provider (but not in EDB Manager) the LOWER function is actually
changing values to UPPER instead (!?).

e.g. select id, lower(name) from tbl is returning :-

--------------------
id | lower(name)
--------------------
1  | FRED
2  | SUE
3  | JOHN

Could do with a fix for this pretty quickly please!!!

Thanks.

Hedley,

<< In the ADO provider (but not in EDB Manager) the LOWER function is
actually changing values to UPPER instead (!?). >>

I'll check this out.  If it works in the EDB Manager, then it should work in
..NET just as well.  The code is exactly the same for both.

--
Tim Young
Elevate Software
www.elevatesoft.com

I checked and double-checked with the same SQL against the same database in
EDB Manager and then again in C# and it's definitely just a problem in C#.

Please let me know if you want a test database and test C# project an I'll
upload one for you.

Hedley,

<< I checked and double-checked with the same SQL against the same database
in EDB Manager and then again in C# and it's definitely just a problem in
C#.

Please let me know if you want a test database and test C# project an I'll
upload one for you. >>

I haven't had a chance to look at this yet, but it should be easy enough to
reproduce without a project.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim - just wondering if you've managed to reproduce this at all?

Hedley,

<< Hi Tim - just wondering if you've managed to reproduce this at all? >>

I'm looking into it this evening when I start on 2.02 B11.  I'm also going
to look into seeing what I can do about the view performance.

--
Tim Young
Elevate Software
www.elevatesoft.com