web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Updating data in table...
Small and medium business | Business Central, N...
Suggested Answer

Updating data in tables in the SSMS

(0) ShareShare
ReportReport
Posted on by Mary Karceva 15

Hello,

I've found the problem - when we update data in tables by the direct query in the database (SQL), new values are not displayed in web-client (or displayed only in list-pages).

For example my query is:

UPDATE TableName SET [Document Status] = 0 where [Document No] = 'X'

*[Document Status] is an option field in BC365

In windows-client i see new value in the [Document Status] field in document 'X'

In web-client i see:

- new value in the [Document Status] field in document 'X' on a LIST page

- old value in the [Document Status] field in document 'X' on a CARD page

What could be the reason? And how can we solve this problen?

(Clearing chache is not helping)

We are using Microsoft Dynamics 365 Buseness Central - 14.0.29530

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Unless there is a specific code on the page that may reference that field value or calculating it.  Did you compile the page and table?

  • Mary Karceva Profile Picture
    Mary Karceva 15 on at

    There is no specific code on the card-page. I've created a new one List-page and card-page - the same result.

    Recompilation helps, but I could not compile objects every time after changing data in the database.

    This is not a usual practice for us to change data by direct queries.

    But I've noticed that specialty and it haunts me.

    By the way - I'm using Edge and Google Chrome.

  • Suggested answer
    Rbansode Profile Picture
    Rbansode 5 on at

    Does refreshing the page not reflect the updated data?

  • Mary Karceva Profile Picture
    Mary Karceva 15 on at

    Refreshing the page does not reflect.

    I've found that the SELECTLATESTVERSION function on OnOpenPage trigger helps. And I also know that this problem is about th database chache. But I still don't understand, how does it work...

  • M Hussnain Javed Profile Picture
    M Hussnain Javed 241 on at

    Go to Windows>Services>Microsoft Dynamics 365 Business Central

    Now restart Microsoft Dynamics 365 Business Central Services and then again try to update data in tables through ssms

    If you've received your answer, please verify it to help others.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    The SelectLatestVersion is the method we used when somebody is making changes directly in the database, because of the cache NAV does directly reflect the data if the update is made directly using queries.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans