[Zope-DB] ZSAPDB Connector Weirdness

[Samir Mishra]

Hello all,

I'm using the ZSAPDB connector and I'm getting some very strange behaviour.

On a table ABC, with columns A, B & C, if I run the query 
select * from ABC
I get back all of the rows.

Now, if I run the query -
select * from ABC order by A
my result set is empty! 

The same query runs as expected when I run it in the SAP-DB SQL Studio.

Has anyone else seen this? If so, is there a fix? If not, I'd like to track
down any version differences.

I'm running SAP, ZOPE, & everything else on Win2000 Server :(

TIA

Regards,
Samir

PS I'm also seeing some other weirdness that I'm attempting to resolve, but
if anyone has