How To Write A While Select Statement

The x++ language in Microsoft Dynamics 365 for Finance and Operations combines the best of both SQL like language and object oriented programming. Developers can efficiently tell the SQL database what records to retrieve. An x++ 'while select statement' allows developers to loop through specific records with ease. Then take action on those records.
#Dynamics365 #Dynamics365Musings #MSDyn365 #MSDyn365Community #DYN365O #D365FO #Microsoft #d365ug #xppgroupies #D365 #WhileSelectStatement #TableBuffer

Subscribe to my channel:


Table of Contents:

00:00 - Intro
00:07 - While Select Statement
01:08 - While Select vs Select Statement
03:33 - Example Select Statement
04:19 - While Select
05:56 - Common Misunderstanding
06:43 - Tools For Viewing All Records
08:06 - SQL Server Management Studio
11:23 - While Select Examples
12:46 - Nested While Selects
14:29 - Combine Select Statements
18:24 - Further Improvements
19:28 - Conclusion
20:27 - Outro

[juanjo]

Thank you for this content, I just got the opportunity to became a developer in the company where I work and X++ is totally new for me, but your videos are helping me a lot.

[froggio]

great content, thank you Peter, you can continue with Queries, containers, etc :) it would be very helpfull ! :), you are becoming on of the best native english speaker AX source :) thank you for this effort

[himanshushekhar]

great peter, thank you so much .please make tutorials on SSRS reports of different types. It will be great help

[TonyTigerTonyTiger]

Twice you seemed to imply that a while select issues a separate call to the database for each iteration inside its curly braces. But a while select issues a single call to the database to retrieve all of the records for that select statement upfront, storing the records in the table buffer; then the while parts loops through the results 1 record at a time. From the Microsoft docs.
"In a while select, the select statement itself is executed only one time, immediately before the first iteration of the statements in the loop."

[vigneshkumar]

Really
What is meant by exist. Join
And why we have to use Backorder

[Hugo-gvqj]

Thanks for sharing!!! You may be interested in P R O M O S M.