Solved

read only text item with lov

Posted on 2014-12-11
4
391 Views
Last Modified: 2014-12-17
hi am in oracle 11gR2 how can i get a read only text item with lov in oracle forms i just what to select value in lov and attach it in my textitem and insert it use cannot type only the value attach by lov must be saved
my lov is

BEGIN
	copy(:cal_erd_link.focusobject,'cal_erd_link.obj_child');
  go_item('cal_erd_link.obj_parent');
  do_key('List_values');
  copy ('0', 'GLOBAL.save_mouse_record');
END;

Open in new window


i what the textitem to be grey out /disable user cannot enter value
0
Comment
Question by:chalie001
  • 2
4 Comments
 

Author Comment

by:chalie001
ID: 40495560
i don't want the user typing in the field, then i could modify my When-Button-Pressed trigger to set the Update Allowed property to TRUE, to let my LOV set the value and then set the Update Allowed property FALSE again
0
 
LVL 22

Accepted Solution

by:
Helena Marková earned 500 total points
ID: 40495651
You can try it with SHOW_LOV:

BEGIN
  copy(:cal_erd_link.focusobject,'cal_erd_link.obj_child');
  IF SHOW_LOV('your_lov') THEN
--     go_item('cal_erd_link.obj_parent');
 -- do_key('List_values');
     copy ('0', 'GLOBAL.save_mouse_record');
 END IF;
END;
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40496718
It looks like your Oracle database version is 11gR2, but the more important issue here is not the database version, but your Oracle Forms version.  Which version of Oracle Forms do you have?  I think any version from Forms6 - Forms11 can work with an 11gR2 database.

You say that want the text item to be greyed out and/or disabled, so the user cannot enter a value, but yet you want the user to be able to "select value in lov and attach it in my text item and insert it".

In Oracle Forms, if the item is disabled, the user will not be able to choose a value from an LOV for that item.  I think you will need the item to be enabled (and not greyed out) so the user can use an LOV on that item.  You can add a WHEN-VALIDATE-ITEM trigger to make sure that whatever value the user chooses (or types in manually) matches a valid value that is in the LOV.
0
 

Author Closing Comment

by:chalie001
ID: 40505282
correct
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
statspack purge automate 7 51
PL/SQL - Leading zeros 7 57
Clone Oracle 12c Database 5 42
grouping on time windows 6 41
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now