Page History
...
| Code Block |
|---|
List CUSTOMERS Limit INVOICE_DATE From "1-1-95" TO "12-31-95" List CUSTOMERS Limit INVOICE_AMOUNT Between 1000 And 5000 |
Each value in the multi-valued column will be compared to the range. If the value in the column falls within the range specified by the range (inclusive), it will be displayed.
...
| Code Block |
|---|
List CUSTOMERS COMPANY Limit INVOICE_AMOUNT >= "1000" |
...
This command lists the company name of all customers, and lists all values from the multi-valued column INVOICE_PAID_DT in which the date is greater than the contents of the column INVOICE_DUE_DT.
| Code Block |
|---|
List CUSTOMERS COMPANY Limit INVOICE_PAID_DT GT INVOICE_DUE_DT |
...
This command lists the company name of all customers, and displays all of the values from the multi-valued column INVOICE_DATE in which the value falls into the range of 1-1-95 to 12-31-95 (inclusive).
| Code Block |
|---|
List CUSTOMERS COMPANY Limit INVOICE.DATE From "1-1-95" To "12-31-95" |
...
| Code Block |
|---|
* Run_Report examples
* Display all Orders and display only Item 3542-1-310-1 from the
* multivalue list.
stmt = 'LIST ORDERS CUSTOMER_NAME ITEM DESCRIPTION '
stmt:= ' LIMIT ITEM "3542-1-310-1"'
Run_Report("",stmt)
* Display only Orders containing Item 3542-1-310-1 and display only
* Item 3542-1-310-1 from the multivalue list.
stmt = 'LIST ORDERS CUSTOMER_NAME ITEM DESCRIPTION '
stmt:= ' LIMIT ITEM "3542-1-310-1" WITH ITEM [] "3542-1-310-1"'
Run_Report("",stmt) |
