Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.06 » View Incident Report |
Minor |
Reported By: Alec Reported On: 11/6/2007 For: Version 1.05 Build 2 |
CREATE TRIGGER "MailAccountAfterDelete" AFTER DELETE ON "MailAccounts" BEGIN DECLARE MailFoldersCursor SENSITIVE CURSOR FOR MailFoldersStatement; PREPARE MailFoldersStatement FROM 'SELECT GUID FROM MailFolders WHERE MailFolders.AccountID = ?'; OPEN MailFoldersCursor USING OLDROW.GUID; START TRANSACTION ON TABLES MailFolders; BEGIN WHILE NOT EOF(MailFoldersCursor) DO DELETE FROM MailFoldersCursor; END WHILE; COMMIT; EXCEPTION ROLLBACK; END; 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 |