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

Notifications

Announcements

Season of Giving Solutions is Here!
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 (185)
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