Ship-to status value set to order status value

ITEM: RTA000157297



Q:                                                                              
Topic thread:                                                                   
e-Commerce Solutions                                                            
 Net.Commerce for AIX                                                           
                                                                                
Why is there a trigger to set the ship-to status (STSTAT) value to that         
of the order (ORSTAT)?  Why even have a ship-to status if it's always           
that of the parent?  What are the implications if I drop this trigger?          
                                                                                
                                                                                
                                                                                
A:                                                                              
The triggers are set to enforce certain business rules and to                   
maintain integrity of the database.  You should not remove any of               
the triggers or you could compromise the integrity of the database.            
You may create your own triggers using the appropriate SQL statements,          
but you should not remove any of the existing triggers.                         
                                                                                
Information on the triggers can be found in the "Net.Commerce                   
Commands, Tasks, Overridable Functions and Database Tables"                     
document.  Search for 'Triggers for Database Tables'.                           
                                                                                
S e a r c h - k e y w o r d s:                                                  
triggers                                                                        
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                               


WWQA: ITEM: RTA000157297 ITEM: RTA000157297
Dated: 06/1999 Category: NCAIX
This HTML file was generated 2000/11/30~13:34:10
Comments or suggestions? Contact us