web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... select for update x++

Finance | Project Operations, Human Resources, ...

Suggested Answer

select for update x++

(0) Share

Report

Report

Posted on by DELDYN

554

Hi,

When we do

ttsbegin;

select for update table1 where table1.Id =='A'; //first DB hit

table1.Field1 = "X";

table1.update(); //second DB hit

ttscommit; //third DB hit

is it really 3 database calls?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Suggested answer

Deepak Agarwal 9,101 on at

Like
a
(1)

Report
Copy link

Link copied!

I dont think there will be 3 DB calls, it must be 2 only.

First when you do select for update,

and secondly when you call table.update().

while ttscommit isn't a query its just commits the transaction but it does interact with SQL but doesnt fetch or modify any data.

Was this reply helpful? Yes No
Suggested answer

Subra 1,479 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

I hope only 2 calls for DB not 3 DB calls.

Only for Select and Update.

Thanks,
Subra

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 305,938 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Deldyn,

Actually, there are three database operations with your example. Two calls on the table, and one command for managing the consistency of the database.
There is a read, an update, and transaction commitment.

In case of multiple updates, the ttscommit will mark the database changes as complete. If you encounter an error, you can use ttsabort, which will remove all uncommitted changes. If you want to learn a bit more, you can read a blog post where I wrote about interacting with uncommitted changes: How to: Read uncommitted records using Dynamics 365 for Operations.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Abhilash Warrier 461 Super User 2026 Season 1

#2

André Arnaud de Cal... 458 Super User 2026 Season 1

#3

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans