Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Altering a trigger in EDBManager |
Wed, Jun 11 2008 2:18 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Wed, Jun 11 2008 4:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Jun 12 2008 2:26 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |