RE: UPDATE T SET X = X + 1 increments by 2 when executed inside a function

Hello Martin,

can you try to execute the SELECT that triggers the function with a FOR REUSE added? Does it 
change anything? 

Alexander Schröder
MaxDB & liveCache
SAP AG

Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi, Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269

Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt.
Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank.

This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation.   

-----Original Message-----
From: Martin Cordova [mailto:[email protected]] 
Sent: Dienstag, 20. März 2007 16:14
To: maxdb
Subject: UPDATE T SET X = X + 1 increments by 2 when executed inside a function

Hi, I am new to MAXDB functions, today I tried to create one that:

1) updates a table and increments a certain column value
2) returns a string that incorporates that value, combined with
another piece of data

The thing is that I execute a simple update to increment the value by
1, but it get incremented by 2!!!

I am missing something, any help will be appreciated.

I am using MaxDB 7.6.0.34 on WinXP SP1.

The code:

CREATE FUNCTION XXX.getNumCorrespE (dependencia_id INTEGER) RETURNS VARCHAR AS

    VAR ano INTEGER; cnum INTEGER; retval VARCHAR(20);

TRY

  SET ano = 0;
  SET cnum = 0;

update XXX.dependencia set num_corresp_e = num_corresp_e + 1
where dependencia_id = :dependencia_id;

DECLARE functionresult CURSOR FOR

select
    ano,
    num_corresp_e cnum
from XXX.dependencia
where
dependencia_id = :dependencia_id;

WHILE $rc = 0 DO BEGIN
      FETCH functionresult INTO :ano, :cnum;
    END;
CATCH
  IF $rc <> 100 THEN STOP ($rc, 'unexpected error');
CLOSE functionresult;

set retval = chr(ano) || '-' || LFILL(chr(cnum),'0',6);

RETURN retval;


Regards,
Martin Cordova
-- 
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]