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.
...
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) |