Wednesday, July 4, 2018

Using While Select

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

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...