Wednesday, July 4, 2018

Using Ranges in Select Statements

A range can be set for records being selected. This range is specified in thewhere clause of the select statement using relational operators. The following
example selects customers who have account numbers greater than 4005 and less
than 4017.


1
2
3
4
5
6
7
8
9
CustTable custTable;
while select custTable
where custTable.AccountNum > "4005"
&& custTable.AccountNum < "4017"
{
  print custTable.AccountNum , " 
  ",custTable.currency;
}
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...