DBPROC always camcels UPDATE

Hi all,

I set out to write a DBPROC that updated a field with a value  
calculated by reference to a range of tables in my DB. The intention  
being to improve performance of retrieving data, my query could look  
to this calculated field rather than perform the calculation each  
time. Triggers calling this DBPROC would be placed on tables that  
contributed to the calculated value.

My problem is that calls to the DBPROC are causing the calling trigger  
to silently fail. Clearly I'm doing something pretty foolish but for  
the life of me I can't see what. Here are SQL statements as executed  
through my WEBSQL window that demonstrate my problem.

Kernel   	Kernel 7.6.00 Build 016-123-109-428
Runtime Environment 	W32/INTEL 7.6.00 Build 016-123-109-428

CREATE TABLE TBL1 (COL1 INTEGER)

CREATE DBPROC PROC1 AS RETURN;

CREATE TRIGGER TBL1UPDATE
FOR DBA.TBL1
AFTER UPDATE
EXECUTE (CALL DBA.PROC1;)

INSERT INTO TBL1 (COL1) VALUES (1)

UPDATE TBL1 SET COL1 = 2

At this point I would expect the value of COL1 to be 2, but instead I find 1.

What am I doing wrong here?

Regards,

James Prosser


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