Solved

read only text item with lov

Posted on 2014-12-11
4
447 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
grant user/role question 11 36
run sql script from putty 4 191
oracle sqlplus query delimiter 8 39
What are the limitations of input parameters in oracle ? 5 67
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

733 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