web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / DaxGeek / Using While Select

Using While Select

Views (197)
Hossein.K Profile Picture Hossein.K 6,648
The while select statement loops through many records fulfilling specific criteria
in a table. Use this loop to perform statements on each record. The following
code shows an example of a while select statement. This code loops through the
customer table and prints the account number, name, and address of each record
in the table.

1
2
3
4
5
6
7
8
CustTable custTable;
while select accountNum, currency, creditMax from custTable
{
  print custTable.AccountNum, " ", 
  custTable.currency, "
  ", custTable.creditMax;
  pause;
}

Best Regards,
Hossein Karimi

Comments

*This post is locked for comments