News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... SQL Update Statements

Small and medium business | Business Central, N...

Answered

SQL Update Statements

(0) Share

Report

Report

Posted on by john.ellis

3,482

Hi:

How do you conduct "update" statements in SQL for a Business Central company?

Thanks!

John

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: SQL Update Statements

You should not really be doing direct updates of your Business Central data directly in SQL server. You should do updates through AL code as Zhu is talking about.

And you will only have access to SQL data in BC on-prem - in BC online you do not have direct database access.
Verified answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (1)

Report

RE: SQL Update Statements

Hi, if you want to modify the existing records in a table, you should use the following method.

Record.Modify([Boolean]) Method

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-modify-method

And, Insert, Modify, ModifyAll, Delete, and DeleteAll Methods

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-insert-modify-modifyall-delete-and-deleteall-methods

Hope this helps.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans