[Zope-DB] ZSAPDB Connector Weirdness

Samir Mishra SamirMishra@cbuae.gov.ae
Mon, 28 Jul 2003 13:04:19 +0400

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 :(



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