Home » Developer & Programmer » Forms » Forms query
Forms query [message #222842] Tue, 06 March 2007 11:43 Go to next message
srinivas.k2005
Messages: 342
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



Re: Forms query [message #222864 is a reply to message #222842] Tue, 06 March 2007 14:36 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Forms query [message #225410 is a reply to message #222842] Mon, 19 March 2007 22:14 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Forms query [message #230367 is a reply to message #222842] Wed, 11 April 2007 12:37 Go to previous message
srinivas.k2005
Messages: 342
Registered: August 2006
Senior Member
Yes thanks david the same i implied.
Previous Topic: LOV & Record Group
Next Topic: Can i do this
Goto Forum:
  


Current Time: Sat Dec 10 12:31:20 CST 2016

Total time taken to generate the page: 0.16256 seconds