Alan Bourke wrote: > I need something to apply insert, delete and update triggers to a number > of tables automatically, with a view to logging changes to the data. > > An ex-colleague was telling me about a solution for this a while back, > which I believe was in the public domain, maybe off UT or similar. Does > this ring any bells ?
To create triggers programmatically see CREATE TRIGGER command. Once they're in place you can make them call any program you want, doesn't have to be a stored procedure. Of course it'll barf if the called program isn't there but then that's no bad thing ... -- Cheers ============ Brian Abbott ============ _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
