Home » Developer & Programmer » Forms » oracle form & list item (merged) (oracle 9)
oracle form & list item (merged) [message #425953] Tue, 13 October 2009 06:29 Go to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
hello guys,,, i have text that has date and list item(c-cancelled, a-absent, r-registration,w-waiting list), if sysdate more then the date in the text should just list item showing waiting list and absen, if sysdate less then the date in the text then list item should just showing just cancelled. how to do that ??
thank you for your help.
list item [message #426360 is a reply to message #425953] Thu, 15 October 2009 02:22 Go to previous messageGo to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
hello guys,,, i have text field that has date and static list item(c-cancelled, a-absent, r-registration,w-waiting list), if sysdate more then the date in the text field should just list item showing absent& waiting and cancelled, if sysdate less then the date in the text then list item should just showing just absent. how to do that ?? i already post this problem, but nobody answered.
thank you for your help.
Re: list item [message #426369 is a reply to message #426360] Thu, 15 October 2009 02:56 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Clear your Conditions appling to sysdate and user define date for marking the status through list item automatically

[Updated on: Thu, 15 October 2009 02:57]

Report message to a moderator

Re: list item [message #426372 is a reply to message #426369] Thu, 15 October 2009 03:09 Go to previous messageGo to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
how to do that ?? can you send me any file attachment that show like this condition. thank you
Re: oracle form [message #426404 is a reply to message #425953] Thu, 15 October 2009 05:05 Go to previous messageGo to next message
mubeenmoin
Messages: 15
Registered: April 2009
Location: KUWAIT
Junior Member
write your code on DATE Field as you enter date check date according to your criteria and insert value in LIST ITEM
Re: oracle form [message #426406 is a reply to message #425953] Thu, 15 October 2009 05:21 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Personally I'd use a text-item and an LOV rather than a list-item.
Changing the allowed values for a list item on the fly is problematic.
Re: oracle form [message #426417 is a reply to message #426406] Thu, 15 October 2009 05:50 Go to previous messageGo to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
there is no table to use select statement (Query), it is static list, and in the same time i want to show ALL 4 items and can choose 1 of 4 items in if condition, i don't think we can do than in LOV.
Re: oracle form [message #426418 is a reply to message #425953] Thu, 15 October 2009 05:59 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
SELECT 'a' value, 'absent' description
FROM dual
UNION ALL
SELECT 'c' value, 'cancelled' description
FROM dual
....
etc


Alternatively use a WHEN-VALIDATE-ITEM trigger on the list item to check if the value they've selected is allowed based on the date.
You really don't want to be messing with the contents of the list item on the fly like this.
Re: oracle form [message #426419 is a reply to message #425953] Thu, 15 October 2009 06:02 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Another alternative is to use 2 list items and swap which one is displayed based on the date. If you do that you'll have to use non-database items for the list item and then copy the value to the database item.
I'd probably go with the LOV or WVI trigger.
Re: oracle form [message #428316 is a reply to message #426419] Tue, 27 October 2009 18:56 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Create two record groups and specify which one is to be used before popping up the LOV. Use 'set_lov_property(group_name)'.

David
Re: list item [message #428318 is a reply to message #426360] Tue, 27 October 2009 19:00 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please do not create a new thread for the smae question. Just 'thump' the existing thread.

David
Previous Topic: WHat Software to be installed for Oracle Forms 10g R2
Next Topic: Pre-Insert trigger doesn't fire
Goto Forum:
  


Current Time: Wed Sep 28 19:26:51 CDT 2016

Total time taken to generate the page: 0.08691 seconds