My point was that the messages might be interfering with the mass update.
Emmitt, I have the messages in there only to tell me what procedure is now running. If I do the mass update, I do not see my message that "LAST_MAINT Changed". If I edit a row individually, I do get that message..
- Charles,
- You should expect the trigger to run regardless of the source of the update.
- Try taking out the message and see what happens. Generally, it is not a good idea to have triggers that include screen or user interaction. For example, what happens if the update comes from an ODBC source such as Oterro?
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
