Page History
...
| Parameter | Description |
|---|---|
| CaseSens | Use the CaseSens keyword to force a case-sensitive search of data |
| CaseInsens | Use the CaseInsens keyword to force a case-insensitive search of data. |
| comparison | The comparison operation that is to take place. The same comparison operators (Eq, =, GT, >, etc.) are available as in With clauses. The default is Eq. For details on possible values for the compare word, refer to With. |
| value | Represents the value against which each value in the multi-valued column is to be compared. The value should be enclosed in quotes if it is non-numeric. An example of a value comparison is: List CUSTOMERS Limit INV_DATE > "1-1-95" |
| compare | You can also compare column with another column in the table. Each value of the multi-valued column will be compared against the value in the compare.column. For example: List CUSTOMERS Limit PAID_DATE > DUE_DATE |
| range | The range specifies a set of acceptable values that can be met for the data to be displayed. The range takes the form: From value To value - OR - Between value And value |
Examples
Some examples:
| 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.
This command lists the company name of all customers. In addition, all invoice amounts of $1,000 or greater in the multi-valued column INVOICE_AMOUNT are displayed. Invoice amounts of less than $1,000 are not displayed, even though they may exist.
| 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) |
