Icon View Incident Report

Minor Minor
Reported By: Roy Lambert
Reported On: 6/12/2008
For: Version 2.00 Build 1
# 2657 Altering 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



Resolution Resolution
Fixed Problem on 6/15/2008 in version 2.00 build 2


Products Affected Products Affected
ElevateDB Additional Software and Utilities

Image