You’re offline. This is a read only version of the page.
3,482
Hi:
How do you conduct "update" statements in SQL for a Business Central company?
Thanks!
John
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.
Hi, if you want to modify the existing records in a table, you should use the following method.
Record.Modify([Boolean]) Method
And, Insert, Modify, ModifyAll, Delete, and DeleteAll Methods
Hope this helps.
Thanks.
ZHU
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,151
Super User 2024 Season 2
#2
Martin Dráb
229,963
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (