Home » Developer & Programmer » Forms » urgent help needed please
urgent help needed please [message #86763] Thu, 28 October 2004 21:39 Go to next message
odeveloper
Messages: 34
Registered: September 2004
Member
hi all

i am using 6i & 10g for Forms development and facing a problem if in Text Item or List Item user Changes a value and after some validations i want to revert/undo to previous value, how i can do it????

suppose form item has value A and user change the value to other than A and in a trigger i validate the new value and find it is not valid and want to set/revert back its value to A.

thnak you for a solution.

 
Re: urgent help needed please [message #86764 is a reply to message #86763] Thu, 28 October 2004 22:42 Go to previous messageGo to next message
G.Viswanath
Messages: 3
Registered: October 2004
Junior Member
Hi,

When cursor navigates to the item , you store the existing value in a parameter and then you do the validations if entered value is not correct then retain the value which is been stored in parameter.

regards,
Viswanath.
Re: urgent help needed please [message #86765 is a reply to message #86763] Thu, 28 October 2004 22:47 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
Make use of Get_item_property's DATABASE_VALUE property.

HTH
Regards
Himanshu
Re: urgent help needed please [message #86767 is a reply to message #86763] Thu, 28 October 2004 23:31 Go to previous message
sowram
Messages: 11
Registered: October 2004
Junior Member
When cursor navigates into the item, you store in the value in that text item in a global variable.

After validatations retrive ur old value from that global variable.

sowram
Previous Topic: diff btw built-in and restricted built-in
Next Topic: killing sessions in oracle 9i
Goto Forum:
  


Current Time: Mon Sep 09 17:10:38 CDT 2024