Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.02 » View Incident Report |
Serious |
Reported By: Marcin Reported On: 11/7/2008 For: Version 2.02 Build 3 |
Original trigger: TRIGGER "trg_CreateManufacturerAlias" BEGIN DECLARE Alias VARCHAR(128); IF (COALESCE(NEWROW.Name, '') <> '') THEN SET Alias = ufn_GetManufacturerAlias(NEWROW.Name); IF (COALESCE(Alias, '') = '') THEN SET Alias = NEWROW.Name; END IF; CALL usp_AddManufacturerAlias(NEWROW.ID, Alias); END IF; END Workaround trigger: TRIGGER "trg_CreateManufacturerAlias" BEGIN DECLARE Alias VARCHAR(128); DECLARE ValName CLOB; DECLARE Cur CURSOR FOR Stmt; PREPARE Stmt FROM 'SELECT Name FROM Manufacturer WHERE ID = ?'; OPEN Cur USING NEWROW.ID; IF (ROWCOUNT(Cur) > 0) THEN FETCH FIRST FROM Cur(Name) INTO ValName; IF (COALESCE(ValName, '') <> '') THEN SET Alias = ufn_GetManufacturerAlias(ValName); IF (COALESCE(Alias, '') = '') THEN SET Alias = ValName; END IF; CALL usp_AddManufacturerAlias(NEWROW.ID, Alias); END IF; END IF; CLOSE Cur; 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 |