Form cursor position is changed to start position defined in the data source

(0) Share

Report

Posted on by udaY-ch

4,624

In a customized form, when the form refreshed by pressing F5 or Refresh button in the Action pane list group. The cursor position is changed into start position which we defined in the form data source.

In standard form, Sales table, when the form is changed into grid view and if we refresh, the cursor stays in the current record.

Where does the code require to make the cursor stay in the selected record even after a refresh.

*This post is locked for comments

All responses (2)

Answers (0)

udaY-ch 4,624 on at

Like (0)

Report

RE: Form cursor position is changed to start position defined in the data source

Hi Vilmos,

Thanks for your reply, I do use execute query and by pressing F5, debugger comes to executequery after SysSetupFormRunTask. [research code wasn't used]

The issue got fixed when I change the link type of the form's second datasource from outerjoin to innerjoin.

But I wonder how come the standard form |SalesTable| has multiple data sources with outer join as link types for all its joining data sources.
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Form cursor position is changed to start position defined in the data source

Either your customized code is calling research, or executequery, or a joined datasource is triggering the move of the cursor.

If you do a research in code, you may pass in (true) as a parameter to retain cursor position.

You could try overriding executeQuery on the datasource, put a breakpoint in there and see what is triggering the reread of the datasource (which causes the cursor to reposition to first, or last entry depending on the property setting).