OraFAQ Forum: Forms » update record

Home » Developer & Programmer » Forms » update record

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

update record [message #584864]

Mon, 20 May 2013 01:44

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

hello,

I WANT TO UPDATE THE ALREADY EXISTING RECORD IN MY TABLE,
AND WANT TO KEEP BOTH RECORD IN SAME TABLE.
IN MY FORM.

REGARDS

Report message to a moderator

Re: update record [message #584866 is a reply to message #584864]

Mon, 20 May 2013 01:49

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

The simplest way I can think of is a database trigger. However, logging (i.e. keeping previous record values) is *usually* done in another table, not the same. There's a possibility of violating uniqueness, for example. Which columns can you update? All of them? If not, which ones?

It would help if you provided CREATE TABLE statement so that we'd have some more information.

Report message to a moderator

Re: update record [message #584869 is a reply to message #584866]

Mon, 20 May 2013 02:13

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

i want to keep both the record in same table,the record which get modified,amd the previous record

Report message to a moderator

Re: update record [message #584870 is a reply to message #584869]

Mon, 20 May 2013 02:15

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

as iam working on a form.
so i want to modify one record and save the modified record,and the record which get modified,in same database tabel.
so help me by giving the code and on which button i can apply this code...
i wand to update all columns and want to keep both modified amd privious record in same table,.

[Updated on: Mon, 20 May 2013 02:27]

Report message to a moderator