| oracle form & list item (merged) [message #425953] |
Tue, 13 October 2009 06:29  |
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  |
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 #426372 is a reply to message #426369] |
Thu, 15 October 2009 03:09 |
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 |
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 |
cookiemonster
Messages: 13963
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 |
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 |
cookiemonster
Messages: 13963
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 |
cookiemonster
Messages: 13963
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: list item [message #428318 is a reply to message #426360] |
Tue, 27 October 2009 19:00 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Please do not create a new thread for the smae question. Just 'thump' the existing thread.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
