Navision not showing data until refreshed.

george175

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

TallyHo

I don't know any solution for that other than using a nav service tier and proper cal to update data.

oki

Try SELECTLATESTVERSION ...