Page needs to be refreshed to display Data

doddwell

Hello

I have modified the Purchase Invoice page (ID 51) to display some data in some new "Approval" tables I have created.

Data is Inserted/Modified in the "Approval" tables using a Windows application using Stored Procedures.

It looks as though NAV only ever displays the data as was when Inserted. In order to display the Modified data, the "Refresh (F5)" Page Action has to be pressed. Once refreshed, the page 'remembers' the data for the individual record in it's Modified state even after closing and re-opening the NAV2016 Application.

How do I configure the Page so that it does not need to be refreshed?

Many Thanks.

Kishorm

Hey @doddwell - have you seen my post above re SELECTLATESTVERSION?

RockWithNAV

Dodwell,

If you are doing any kind of operation from the SQl Stored Procedure then the page has to be refreshed or either you reopen the page. How and when can you expect that NAV Page to get it automatically refreshed keeping the Page Idle in Open mode.

Let me know if I misunderstood something.

doddwell

Hello RockWithNAV

Following execution of the SQL Stored Procedure, Closing/Re-opening the Page (even closing/re-opening NAV) does not update the data on the NAV Page. I still have to press Refresh on the Page.

Thanks

RockWithNAV

Thats truly sounds crazy to me because whenever we use to open a NAV Page it automatically gets refreshed. You saying even after closing opening NAV am shocked.

Kishorm

The data is being cached by the service tier, use SELECTLATESTVERSION command to clear the cache and get the latest version of the data from SQL.

Set the following for a very brief description on this command...

https://msdn.microsoft.com/en-us/library/dd355033(v=nav.90).aspx

doddwell

Hello RockWithNAV

That's right - Closing and Re-opening NAV has no effect. I still have to refresh the page. Very strange I know. Any ideas? Thanks

RockWithNAV

Can you please cross check once restarting the NAV Service.

Kishorm

Hey @doddwell - have you seen my post above re SELECTLATESTVERSION?

doddwell

SELECTLATESTVERSION solved my problem. I placed it in the OnInit() event on the page. If I get around to it, guess I should alter my Stored Procedures so that they call NAV Web Services rather than updating the Tables directly. Thanks