JDBC Form Binder and Grid

 
1
0
-1

Hi, trying to populate a Grid with JDBC binder, which the condition of the query needs to reference a form field:


Select c_program_number From app_fd_sow_remarks Where c_program_number = '#form.sow.program_number#'


the "sow" in the #form.sow.program_number# is the parent form table. I can't seem to get it pass the field value from the parent form. What am I doing wrong here?


Thanks.

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      I think that to achieve the effect you need, the program_number field should be a selection list and put the grid in an ajax form, with which you can load the necessary values into a query dependent on a request param variable.

        CommentAdd your comment...