Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to delete list item element at query and run time

543178Feb 2 2007 — edited Feb 2 2007
Hi..friends...I am using forms 6i.
I have to delete one of the list elements based on text item value.
lets say...
1- text item and 1- list item
test item value : T
list item value : L1,L2,L3
Now, table has 3 combinations....i) T L1 ii) T L2 iii) T L3 All of these are stored already in a table.

1)) Now, when user query the form....if the record in table is T L3 then, it should disable third list value item(i.e L3)...so in this case user has ,

T in text item and only L1 and L2 in list item.

2)) this is oposite to 1)). Just writing to make above point more clear.
if table record is T L1 or T L2 then
T in text item and all L1, L2 and L3 in list item.

I used post query trigger at block level and when validate item on list item. but its not working...

I am confused how to do it...using clear_list or delete_list_element....
How to put data values for list item ...hard code it in form builder or add them programatically.....

its very urget any help will be highly appreciated...

Thank you....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2007
Added on Feb 2 2007
2 comments
3,337 views