2 Replies Latest reply on Nov 23, 2012 4:40 AM by Charith Kulawardana

    Set whereclause programmertically

    Charith Kulawardana
      Dear experts,

      I'm developing Jdeveloper
      I have 2 viewobjs.Both having 2 Choise list components( Let say A & B).
      I want to change B depend on the value selected in A.
      Then I set bind variable to the where clause to the query which contain 'B'.
      I added following code to my 'AppModuleImpl' class.

      public void setWhereCluseforViewObj(String RequiredType){

      NameViewObjImpl vo= (NameViewObjImpl)getNameViewObjImpl1();

      Then I call above method within the setMethodForA in ViewAObjRowImpl class.
      Then I set auto submit 'true' for A.

      But after running ,when I change the A page popup nullpoint Exception.
      I guess that i'm calling above method in a wrong place.
      How can I solve this?
      Pls help

      Edited by: Charith Kulawardana on Nov 22, 2012 7:37 PM