OraFAQ Forum: Forms » Updations of table when table is updated

Home » Developer & Programmer » Forms » Updations of table when table is updated

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Updations of table when table is updated [message #232336]

Fri, 20 April 2007 03:34

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?

Report message to a moderator

Re: Updations of table when table is updated [message #232341 is a reply to message #232336]

Fri, 20 April 2007 04:01

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

code insert on on-update trigger.

Report message to a moderator

Re: Updations of table when table is updated [message #232651 is a reply to message #232341]

Sun, 22 April 2007 20:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 05:52:06 CDT 2025