SQL Table Editor Edit Popup Loads Previous Row on First Click (Dashboard Extender / Session State)

Hi everyone,

I am building a SQL Table Editor workflow where the client wants a custom Edit button that opens a popup edit form rather than editing inline in the table.

The issue I am seeing is that the popup sometimes loads the previous row on the first click, even though the backend logic is returning the correct row and the correct values. If I click Edit again on the same row, it loads correctly.

I have already verified the following:

• the selected row is being captured correctly,
• session state is being updated correctly,
• the backend query is returning the correct record,
• the popup fields are bound to the correct parameters,
• and the values are being populated before the Business Rule returns.

Has anyone run into this type of one click behind behavior with a SQL Table Editor + Open Dialog setup?

Is this a known limitation of the SQL Table Editor, or is there a better pattern for a customizable Edit button that opens a popup and always loads the currently selected row?

If this pattern is better handled with a Grid or another component instead, I would appreciate any guidance.

Thanks.