Navision not showing data until refreshed.

george175george175 Member Posts: 26
edited 2016-08-23 in NAV Three Tier
HI All,
I am Inserting and updating data( lot of Item data ) in NAV Database Using Sql stored procedures.
When I tries to run the page in NAV it does not show me data in NAV until I press F5, Refresh button or restart Navision Instance.

Every nav user must press f5 to see update data or just one and navision will update it for everyone?

Is there some solution how to avoid this? CurrPage.Update on AfterGetRecordTrigger ( Error : A transaction must be started before changes can be made to database ) or OnOpenPage (Error : Another user has modified record for this Item after you retrieved it from database......) doesnt work and WSHShell.SendKeys('{F5}'); solution isnt really good.


George

Answers

  • TallyHoTallyHo Member Posts: 415
    edited 2016-08-23
    I don't know any solution for that other than using a nav service tier and proper cal to update data.
  • okioki Member Posts: 46
    Try SELECTLATESTVERSION ...
Sign In or Register to comment.