Home » Developer & Programmer » Forms » list item - change default value (oracle 10g)
list item - change default value [message #427940] Mon, 26 October 2009 08:39 Go to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
i have list item have 2 value (R- register, A- absent), the default value is (A) , and i have 2 text item ( one has date1) and the second one have ( date 2), i want to change the default value for list item, so when date1 > date2 the default value will be (A), when date1 < date2 the default value will be (R). can i do that ?? and how ??
Re: list item - change default value [message #431332 is a reply to message #427940] Mon, 16 November 2009 22:25 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You can not specify the default value on the fly.

However, you can populate an item in the 'when-create-record', 'pre-text-item', or 'when-validate-item' triggers.

I assume that you will populate date1 and date2 before the user gets to the 'listed' item. In the 'pre-text-item' trigger, if the item is empty then populate it with the desired value. If the user wishes to change it, they can.

David
Previous Topic: ora-06508 error while using client_text_io.fopen()
Next Topic: Make a form view only from some responsibilities
Goto Forum:
  


Current Time: Fri Sep 20 06:33:46 CDT 2024