Home » Developer & Programmer » Forms » update record
update record [message #584864] Mon, 20 May 2013 01:44 Go to next message
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
Re: update record [message #584866 is a reply to message #584864] Mon, 20 May 2013 01:49 Go to previous messageGo to next message
Littlefoot
Messages: 18844
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.
Re: update record [message #584869 is a reply to message #584866] Mon, 20 May 2013 02:13 Go to previous messageGo to next message
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
Re: update record [message #584870 is a reply to message #584869] Mon, 20 May 2013 02:15 Go to previous messageGo to next message
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

Re: update record [message #584871 is a reply to message #584870] Mon, 20 May 2013 02:19 Go to previous messageGo to next message
Littlefoot
Messages: 18844
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Have a look at example I created some time ago. Adjust it so that it fits your needs.

Also, review results returned by Google.
Re: update record [message #584877 is a reply to message #584871] Mon, 20 May 2013 02:55 Go to previous messageGo to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
how can i implement this on my form.
Re: update record [message #584879 is a reply to message #584877] Mon, 20 May 2013 03:00 Go to previous message
Littlefoot
Messages: 18844
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Form doesn't do that; database trigger does.
Previous Topic: Getting size of image in forms 6i
Next Topic: save pdf file using dde in oracle forms
Goto Forum:
  


Current Time: Wed Apr 23 19:04:35 CDT 2014

Total time taken to generate the page: 0.12177 seconds