problems with updates

From: bryan munday <bardy_at_MailAndNews.com>
Date: Tue, 8 May 2001 07:41:04 -0400
Message-ID: <3B020C15@MailAndNews.com>

Hello,

I am having a problem trying to work out how to do the following.

I have many items in a table but want to keep a record, on the table, when just a few of the items have been changed. It is important that the date is kept on the table itself if at all possible.

My original idea, without thinking it through, was to place a trigger on the tabble, which would fire when the table was updated, and then update the table. As you can now see you just ends up with recurrsive firing of the trigger. Any method I think of using triggers causes the samne problem.

I summary I need a way to update a table, when the table has been upadated.

Any help is greatly appreciated.

Bryan

Bryan.munday_at_parexel.com

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Tue May 08 2001 - 06:41:04 CDT