Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Navision not showing i...
Microsoft Dynamics NAV (Archived)

Navision not showing imported/updated data via sql procedure until refreshed

(0) ShareShare
ReportReport
Posted on by George Husek

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Navision not showing imported/updated data via sql procedure until refreshed

    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

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Navision not showing imported/updated data via sql procedure until refreshed

    What error have you faced? Can you put a screenshot here?

  • George Husek Profile Picture
    George Husek on at
    RE: Navision not showing imported/updated data via sql procedure until refreshed

    User have to push button od Item list,I tried CurrPage.UPDATE  on openPage or aftergetrecord trigger on ItemCard but i gor error.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Navision not showing imported/updated data via sql procedure until refreshed

    Hi,

    Is the SQL procedure triggered by user action?  If that's the case, have you tried using the CurrPage.UPDATE statement after the SQL trigger.

  • George Husek Profile Picture
    George Husek on at
    RE: Navision not showing imported/updated data via sql procedure until refreshed

    SQL procedure is running from SQL Agent, which run user from Navision function

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Navision not showing imported/updated data via sql procedure until refreshed

    How SQL procedure is running ? It is run using SQL management studio or run from Navision ???

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans