3 Replies Latest reply on Dec 6, 2012 9:10 AM by 978334

    Need Help in Create Dynamic VO

    978334
      Hi experts,
      Need code to create Dynamic VO

      --
      MD
        • 1. Re: Need Help in Create Dynamic VO
          Shrikant A
          Hi MD,
          used following code

          String sql1 = "SELECT col1,col2,col3 from table1 where ";
          sql1 = sql1 + " col1 =:1";
          ViewObject vo = am.findViewObject("<<VO_NAME>>");
          if (vo == null)
          vo = am.createViewObjectFromQueryStmt("<<VO_NAME>>", sql1);
          vo.setWhereClauseParams(null);
          vo.setWhereClauseParam(0, <<Value to pass>>);
          vo.executeQuery();

          --
          thanks,
          Shrikant
          • 2. Re: Need Help in Create Dynamic VO
            Sushant Sharma
            Hi,

            Refer below link :

            http://anuj-oaframeworkblog.blogspot.in/2009/09/create-run-time-vo-in-oa-framework.html

            --Sushant                                                                                                                                                                                                                                                                   
            1 person found this helpful
            • 3. Re: Need Help in Create Dynamic VO
              978334
              Thanks Friends..