Home » Developer & Programmer » Forms » Updations of table when table is updated
Updations of table when table is updated [message #232336] Fri, 20 April 2007 03:34 Go to next message
lunatic8806
Messages: 10
Registered: March 2007
Junior Member
I have a column called line_id.Now when ever this column is updated in my form the, the table should contain the original row as well as the updated row. How can this be done?
Re: Updations of table when table is updated [message #232341 is a reply to message #232336] Fri, 20 April 2007 04:01 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

code insert on on-update trigger.
Re: Updations of table when table is updated [message #232651 is a reply to message #232341] Sun, 22 April 2007 20:41 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I would suggest using either the pre-update or post-update triggers, not the on-update. Read the documentation for the reasons.

David
Previous Topic: Parameters
Next Topic: Populate listbox in the Post-Query trigger
Goto Forum:
  


Current Time: Sat Dec 03 01:22:07 CST 2016

Total time taken to generate the page: 0.08710 seconds