Tim

Trying to create an after delete trigger (below my sig) and when I click OK I get "cannot focus a disabled or invisible window"


Roy Lambert


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

Roy,

<< Trying to create an after delete trigger (below my sig) and when I click
OK I get "cannot focus a disabled or invisible window" >>

Is this reproducible ?  I've had several reports of this, but cannot
reproduce it here at all.  It has something to do with an incorrect focus
setting, but I cannot seem to find it.  I've tried causing errors,
everything, and it just doesn't happen here.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Is this reproducible ?

Well I managed to do it at least twice, trouble is I'm not to sure how, but rough outline goes:

1. create new trigger
2. screw up code so I get an error
3. click OK a few times in frustration, or to read the error message
4. cancel
5. search the newsgroups for correct code
6. cut'n'paste code into trigger
7. click OK to find out this code is wrong as well
8. alter code to correct
9. click OK get the unable to focus error

Roy Lambert