Current Position:Home > Cannot select different values from a table in a view object

Cannot select different values from a table in a view object

Update:10-11Source: network consolidation
Advertisement
Hi everyone,
I have two tables, Employee : ID, NAME, SALARY, NO_ROLE and role : ROLE_ID, ROLE_EMP. I join them with NO_ROLE and ROLE_ID. I created a view object with these two tables in JDeveloper, I made a LOV with ROLE_EMP and I want to be ale to create an employee with his ID, NAME, SALARY and by choosing a value in the ROLE_EMP list. The problem is that when I choose a ROLE_EMP, I cannot commit because the link between ROLE_EMP and ROLE_ID is not made correctly in ADF.
In SQL, that's what I'm trying to do: INSERT INTO Employee VALUES (ID, NAME, SALARY, NO_ROLE) WHERE NO_ROLE = ROLE_ID of the ROLE_EMP I have selected.
Thanks for your help ;)
PS: I followed this tutorial to do this, but it is not exactly what I want to do: http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_55/jdtut_11r2_55_2.html

The Best Answer

Advertisement
To be more generic, when I create an employee and select his role_emp (the name of the role) I want that the role_id of the role_emp to commit.
  • Cannot select different values from a table in a view object Update:10-11

    Hi everyone, I have two tables, Employee : ID, NAME, SALARY, NO_ROLE and role : ROLE_ID, ROLE_EMP. I join them with NO_ROLE and ROLE_ID. I created a view object with these two tables in JDeveloper, I made a LOV with ROLE_EMP and I want to be ale to c

  • ADF -how to create table binding when view object is no known until runtime Update:10-11

    I want to programmatically create a table binding to a view object where the view object name is not known until run-time. Then I will use a dynamic table to display it. Can anyone provide an example?I looked at example #9. It gets me closer to what

  • Unable to create ADF Table based on view object Update:11-30

    Hi I am using Jdeveloper 11.1.1.5 I have created a view object based on the entity object. I am trying to drag and drop view object from data controls in to a blank page and choosing table -> ADF Table. The table is not getting created and at the sam

  • Select data from all the table names in the view Update:11-30

    Hi, "I have some tables with names T_SRI_MMYYYY in my database. I created a view ,Say "Summary_View" for all the table names with "T_SRI_%". Now i want to select data from all the tables in the view Summary_View. How can i do that

  • How to create dynamic View Object and Dynamic Table Update:10-11

    Dear ll I want to create a dynamic view object and display the output in a dynamic table on the page. I am using Jdeveloper 12c "Studio Edition Version 12.1.2.0.0" This what I did: 1- I created a read only view object with this query "Selec

  • Using case when statement in the select query to create physical table Update:10-11

    Hello, I have a requirement where in I have to execute a case when statement with a session variable while creating a physical table using a select query. let me explain with an example. I have a physical table based on a select table with one column

  • Selecting multiple rows in a table Update:10-11

    Hi All, I have one problem with selecting multiple rows in a table.I tried with setting table property-selectionMode as Multi, but i dinn't get the solution. please provide me solution for this. Thanks & Regards, Sreelakshmi.HI Int leadSelection = wd

  • How to get the selected rows & columns in the table? Update:10-11

    hi everybody,                      In my application the table is kept inside the event structure.I select the cells  in the table (using mouse) on running time.How to get the selected number of rows & columns in that table?Hello, You can fill select

  • How to get selected  row index  of a Table ? Update:10-11

    hi gurus,I'm new  to Webdynpro for abap I'm displaying    just Flight details in a Table  so how to get selected  row index  of a  Table  and need  to be display in Message manager.Hi, For getting the row index use the following code. DATA lo_nd_node

  • How to get selected row values in a table using check box Update:10-11

    Hi ADF Experts, JDEV Version 11.1.1.7.0 My requirement is getting the selected row valuesof a af:table using a checkbox(multi select). Thanks, AnimeshHi, add a transient attribute to the POJO entity and update this through a check box. The ensure you