How to get data from a grid current row and send them to the appropriate controls of the dialog window

Hi Dmitry,

As an addition to Michiel's answer, before displaying your dialog, you should set the right clicked row of your grid component as the current row of your datasource using api_component.getrightclickedrowid and api_datasource.setcurrentrow APIs at rightClick event of your grid.

procedure gridRightClicked is
  v_rightClickedRow_id number;
begin
  v_rightClickedRow_id := api_component.getrightclickedrowid(your_panelDotGridComponent_name);
  api_datasource.setcurrentrow(your_datasource_name, v_rightClickedRow_id);
...
end;

Kind Regards, Ibrahim

Hi Dmitry,

Different approach can be to not create 3 different datasources, but create one datasource, one grid and one dialog and set the where clause of the datasource dynamically using api_datasource.setFilterWhereClause

If you can use this approuch depends a bit on your usecase though.

Hi,

This is how you do it: Create a dialog window and a panel with the necessary controls. When creating the controls, just link them to the same datasource as the grid, like for example:

<textField column="your_datasource_column_name" dataSource="your_datasource_name"/>

Formspider will then automatically show the current row data of the defined datasource.

best regards, Michiel

Hi Dmitry,

To achieve this, create 3 separate panels based on each of your data-set and create a single dialog box. In your dialog XML, enter a cell name value for the dialog cell which will contain your panel. In the following example, "cell_center" is used as the cell name;

<dialog width="500" height="500">
  <borderLayout>
    <cell docking="Center" name="cell_center"/>
  </borderLayout>
</dialog>

Then, just before displaying your dialog box, place the appropriate panel in your dialog box using the api_dialog.addPanel API;

...
 api_dialog.addpanel(your_dialog_name, 'cell_center', panel_name_to_be_displayed);
 api_dialog.setVisible(your_dialog_name, 'Y'); 
...