You’re offline. This is a read only version of the page.
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
*This post is locked for comments
It would be safer to run through a report your sql procedure (it requires a brunch of lines in order to call stored procedure via NAV), and to call an update once report action is completed
What error have you faced? Can you put a screenshot here?
User have to push button od Item list,I tried CurrPage.UPDATE on openPage or aftergetrecord trigger on ItemCard but i gor error.
SQL procedure is running from SQL Agent, which run user from Navision function
How SQL procedure is running ? It is run using SQL management studio or run from Navision ???
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (