How to set focus to current row and column after executequery command

Question

Hi all,

I wanted to setfocus back to the current row and column after issuing an executequery command in a grid. I issued the following commands. However, this is not working as the rowid changes after every execute query command and therefore setcurrentrow command will not work correctly. Can you kindly suggest me an alternative solution?

PROCEDURE refreshgrid IS
   l_focused_item  VARCHAR2(100);
   l_ds            VARCHAR2(200);
   l_rowid         NUMBER;
BEGIN
   l_focused_item   := api_application.getfocusedcomponent('Y');
   l_ds             := api_component.getdatasource(l_focused_item);
   l_rowid          := api_datasource.getcurrentrowid(l_ds);
   --
   api_datasource.executequery(l_ds, NULL);
   --
   api_component.requestfocus(l_focused_item);
   api_datasource.setcurrentrow(l_ds, l_rowid);
END;

With regards.

George

Answer 1

0

Hi George,

I guess you will need to get the primary key value of the row, so you can return to the row after executequery using api_datasource.setcurrentrowbypk
You can combine it with api_datasource.getpkcolumnname to get the PK column for the datasource and use that to get the columnvaluenr of the PK column.

Best regards,
Michiel

link

answered 08 Apr '14, 10:45

Michiel A
516●2●18●52
accept rate: 13%