Re: Trigger

[MWalter@xxxxxxxxxxxxxxx]

Yea, found that out the hard way.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@xxxxxxxxxxxxxxx
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \



                                                                                
                                                                      
                    Mlpolutta@xxxxxxx                                           
                                                                      
                    Sent by:                     To:     
midrange-l@xxxxxxxxxxxx (Midrange Systems Technical Discussion)                 
             
                    midrange-l-bounces@xx        cc:                            
                                                                      
                    drange.com                   Subject:     Re: Trigger       
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      
                    03/05/2003 03:39 PM                                         
                                                                      
                    Please respond to                                           
                                                                      
                    Midrange Systems                                            
                                                                      
                    Technical Discussion                                        
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      




Because you are effectively deleting records, but in a way that the trigger
cannot fire.  You must delete the records one-at-a-time so the trigger can
fire.  SQL will do this (DELETE FROM xxxxx).

Michael

> Then why do you get an error when clearing a file with a
> trigger?
>
>
> Thanks,
>
> Mark
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.