Hi, Im trying to populate a field automatically in the grid using the grid control. It looks like the function rbv_api.selectValue doesn't accept arguments in the grid control. Without argument, i get the right value in the field, see examples below: This does not work: script> function rbf_showGridRow(rowIndex) { var obj_id = 'Myvalue'; rbf_setGridContent2(0, 'testfield', rowIndex, #EVAL[rbv_api.selectValue("SELECT mycolumn FROM mytable where name=?", obj_id)]); } /script> This works: script> function rbf_showGridRow(rowIndex) { var obj_id = 'Myvalue'; rbf_setGridContent2(0, 'testfield', rowIndex, #EVAL[rbv_api.selectValue("SELECT mycolumn FROM mytable where name='Myvalue'")]); } /script> Can you please take a look and let me know your thoughts? Thanks in advance! Rgrds, Bakar
You're mixing server-side and client-side API. In first case obj_id is unknown when page is rendered, so #EVAL[] cannot bring up meaningful results.
Please use client-side API only.
marking as solved: server-side API cannot be used on client-side