Reported By: Roy Lambert Reported On: 6/12/2008 For: Version 2.00 Build 1
# 2657Altering a Trigger in a Way that Causes a Non-SQL Error Causes "Unable to Focus" Error Trying to create an after delete trigger (below my sig) and when I click OK I get "cannot focus a disabled or invisible window".
BEGIN
DECLARE Zapper SENSITIVE CURSOR FOR ZapperSQL;
DECLARE txt VARCHAR;
SET txt = 'SELECT * FROM emReadStatus WHERE emReadStatus._fkEMails = '+CAST(OLDROW._MsgNo AS VARCHAR);
PREPARE ZapperSQL FROM txt;
OPEN Zapper;
START TRANSACTION ON TABLES Zapper;
BEGIN
WHILE NOT EOF(Zapper) DO DELETE FROM Zapper;
END WHILE;
COMMIT;
EXCEPTION
ROLLBACK;
END;
END
ResolutionFixed Problem on 6/15/2008 in version 2.00 build 2
Products AffectedElevateDB Additional Software and Utilities