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