AW: Strange problem with SAPDB 7.4.03.27

I have one addition:

My workaround works not correctly. Now Access interprets the last row of my
result as strings and I can't use them for my report. 


-----Ursprüngliche Nachricht-----
Von: Hübschen, Peter 
Gesendet: Dienstag, 28. Oktober 2003 11:17
An: Mailingliste MaxDB (E-Mail)
Betreff: Strange problem with SAPDB 7.4.03.27


Hello, 

I've developed an Access-App 97 with an SAPDB-Backend. Some days ago I
updated vom 7.4.03.25 to 7.4.03.27 on a RH 9 Box. Now I'm having a strange
problem with the follwing stored procedure.

CREATE DBPROC SP_RPTAUSWERTUNG (IN ANFANG DATE, IN ENDE DATE, IN SPARTE3
CHAR(2), IN SPARTE1 CHAR(2))
RETURNS CURSOR AS
$CURSOR = 'rptAuswertung_Cursor';
DECLARE :$cursor CURSOR FOR
        
        SELECT ANGEBOTE.GESAMT, 'Anzahl abgegebene Angebote' AS TITEL,
DECODE (ANGEBOTE.GESAMT, 0, 0, Fixed(1,5,4)) AS PROZENT
        FROM
        .....
             
        UNION

        SELECT ERHALTEN.ANZAHL, 'Anzahl erhaltene Aufträge' , DECODE
(ANGEBOTE.GESAMT, 0, 0, FIXED(ERHALTEN.ANZAHL / ANGEBOTE.GESAMT,10,4))
        FROM
           ....
        UNION        
           ....

If I execute this proc in SQLStudio I get the values I want:
x  Anzahl abgegebene Angebote      1
y   Anzahl Projekte gestorben       .xxxx
....

If I execute my proc from Access through a Pass-Through-Query, everything
worked fine with SAPDB version .25. After my upgrade to .27 I get the
following results:
x  Anzahl abgegebene Angebote      1
y   Anzahl Projekte gestorben          0
z  Anzahl bla                                  0
....                                                 

At least I found a workaround by changing Fixed(1,5,4) to Fixed(1,5,4)/1,
but I think it's very strange.


Mit freundlichen Grüßen

      P. Hübschen


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/maxdb?unsub=peter.huebschen@xxxxxxx




--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx