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

(0) Share

Report

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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

Was this reply helpful? Yes No
George Husek on at

Like (0)

Report

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

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
George Husek on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No