Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.02 » View Incident Report |
Serious |
Reported By: Shane Sturgeon Reported On: 11/15/2008 For: Version 2.02 Build 3 |
TRIGGER "AfterDeactivation" BEGIN CALL monUpdate_ReplaceWith(NEWROW.monID, NEWROW.monReplaceWith); END PROCEDURE "monUpdate_ReplaceWith" (IN "OldValue" INTEGER, IN "NewValue" INTEGER) BEGIN -- Prepare the Selection Query with parameter. DECLARE MoneyCmpCursor CURSOR WITH RETURN FOR Stmt; PREPARE Stmt FROM 'SELECT * FROM MoneyCmp WHERE monReplaceWith = ?'; OPEN MoneyCmpCursor USING OldValue; -- Now update the selected records. START TRANSACTION ON TABLES MoneyCmp; BEGIN FETCH FIRST FROM MoneyCmpCursor; WHILE ROWCOUNT(MoneyCmpCursor) > 0 DO UPDATE MoneyCmpCursor SET monReplaceWith = NewValue; FETCH FIRST FROM MoneyCmpCursor; END WHILE; COMMIT; EXCEPTION ROLLBACK; RAISE ERROR CODE 10000 MESSAGE 'Timeasure DB Error - ' + ERRORMSG(); END; END
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |