James Prosser wrote : > > 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] > >
Hi James, first, you are doing nothing wrong. The result after the update should be 2 , not 1. However, I tried to reproduce the problem, unfortunately without success. In my tests the result has always been 2. I would therefore like to see a vtrace of the problem from your database. Could you please be so kind to send it to me ? Thanks and best regards, Thomas Thomas Anhaus SAP AG mailto: [EMAIL PROTECTED] www.sap.com 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. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
