Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: James Prosser (jamesportal.com.au)
Date: Wed May 30 2007 - 02:00:57 CDT
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
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?
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb