How to use Not exist join with Update_recordset

(1) Share

Report

Posted on by Mohammed Raziq Ali

Can we use notexist join with update_recordset? Is it feasible?

Regards,

Raziq

I have the same question (0)

All responses (6)

Answers (2)

Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi Raziq,

Did it you try it? Or do you have a code that you tried?

Thanks,

Layan Jweihan

Was this reply helpful? Yes No
Mohammed Raziq Ali 4 on at

Like (0)

Report

I tried with notexist join but it didn't work.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Yes, you can use not exist join. It should work. Can you please send your code? Also did you check the same in SQL? May be if there are records existing with given condition so it did not work.

Was this reply helpful? Yes No
Verified answer

Judy Microsoft Employee on at

Like (1)

Report

Hi,

I think it should possible. Have you tried with the X++ SQL in the below blog, I am not sure if it can help since it very old.

https://amannain.blogspot.com/2014/04/using-updaterecordset-with-views.html

Have you tried these X++ SQL Statement with where sub-statement:

CustTable custTable;
ttsBegin;
update_recordset custTable
setting CreditMax = 5000
where not exists (select * from otherTable)
........
ttsCommit;

Best Regards,

Judy

Was this reply helpful? Yes No
Verified answer

Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (1)

Report
Hi Mohammed,

I just tried it and it works perfectly fine.
CustTable custTable; SalesTable salestTable; update_recordset custTable setting accountstatement = 1 where custTable.DataAreaId == 'AA' notexists join salestTable where salestTable.CustAccount == custTable.AccountNum && salestTable.DataAreaId == 'AA';

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
Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Do you still need help with this? If not then please verify the answers that helped you.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to use Not exist join with Update_recordset

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

How to use Not exist join with Update_recordset

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates