OraFAQ Forum: Forms » Forms query

Home » Developer & Programmer » Forms » Forms query

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

Forms query [message #222842]

Tue, 06 March 2007 11:43

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

I have date field in form.
I want previous date before changing,is there any built in to trap the previous date just before changing the date.

Ex:In my purchase date field i have:

02-jan-2007

I change it to 04- mar-2007

So i should have a built in to trap before date i.e,
02-jan-2007.

Same way i go on changing the date,but i want to keep track of just before old date even after changing.

again i change the date 04- mar-2007 to 05-jun-2009

So i should have track of 04- mar-2007 .

Please let me know do we have any built to track exact previous value/date.

Please let know other than global parameters or record groups.

Thanks,
Srinivas

Report message to a moderator

Re: Forms query [message #222864 is a reply to message #222842]

Tue, 06 March 2007 14:36

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

Senior Member
Account Moderator

You might create a database trigger which would take notes of values' changes on this table.

Report message to a moderator

Re: Forms query [message #225410 is a reply to message #222842]

Mon, 19 March 2007 22:14

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

You could create a non-database item on the record (eg original_date) and populate it in the Post-Query trigger. Then each time you change the database value you can perform some logic and then in the Post-Commit trigger assign the new value to the 'original_date' value so that it conforms to the value stored in the database.

In the database an update trigger will have the ':new.purchase_date' and ':old.purchase_date' values available to it.

David

Report message to a moderator

Re: Forms query [message #230367 is a reply to message #222842]

Wed, 11 April 2007 12:37

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Yes thanks david the same i implied.

Report message to a moderator

Previous Topic:	LOV & Record Group
Next Topic:	Can i do this

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 26 18:14:54 CDT 2024