Select forupdate in X++ only update first record of the table

(1) Share

Report

Posted on by Roy Saliba

Hello,

I have a table and I used select forupdate but it only updates the first record using X++.

How can I update all the records that are under the condition of the query.

I have the same question (0)

All responses (6)

Answers (0)

Anton Venter 20,385 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hello,

You probably have an incorrect syntax or doing a "select first" in your statement. The easiest way is to do a "while select forUpdate" statement, change the data and call the update method. This is a slow method. Use update_recordset for faster set based operations.

Please share your code so that we can see and help you. Remember to format your code using the insert code snippet button :-)

Was this reply helpful? Yes No
Roy Saliba on at

Like (0)

Report
Copy link

Link copied!

I used while loop thank you!

Was this reply helpful? Yes No
Waed Ayyad 9,047 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Can you share your code? Also, it is better to use update_recordset method.

Did you add ttsBegin; and ttsCommit;?

Thanks

Waed Ayyad

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

Was this reply helpful? Yes No
Anton Venter 20,385 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!
See the update_recordset example below from the article, also see link below. This is a much faster update method if updating a lot of data compare to a while select forUpdate statement. The article shows important information about updates. Do mind sharing your code?

CustTable custTable; ttsBegin; update_recordset custTable setting CreditMax = custTable.CreditMax + 1000 where custTable.CreditMax > 0; ttsCommit;

Update data

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-data/xpp-update

Was this reply helpful? Yes No
Layan Jwei 8,133 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Select for update will only update one record, even if more than one record matches this condition.

So if u do this:

CustTable custTable;

ttsBegin;

select forUpdate custTable

where custTable.CustGroup == '2';

custTable.Field1 = 1;

custTable.update();

ttsCommit;

And let's say you have two customers that belong to this custGroup, then only one customer will be updated.

If you want all customers with this custGroup to be updated, then you have two options:

1. While loop

CustTable custTable;

ttsBegin;

While select forUpdate custTable

where custTable.CustGroup == '2'

{

custTable.Field1 = 1;

custTable.update();

}

ttsCommit;

2. update_recordset

CustTable custTable;

ttsBegin;

update_recordset custTable

setting Field1 = 1

where custTable.CustGroup = '2'

ttsCommit;

update_recordset is better for performance, but if the update method of the table is overridden, then update_recorset will work as if it was while loop. I mean the performance won't be any better.

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future.

Was this reply helpful? Yes No
Waed Ayyad 9,047 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks
Waed Ayyad

Was this reply helpful? Yes No