DSP® Application Development
Enable List Where Clause
Refer to Add List Boxes and Combo Boxes for general information.
To create a List Where Clause:
- Vertical View for a list box or combo box.
-
Click Edit.
- Click the Advanced Properties tab.
- Enter the WHERE clause in the List Where Clause field.
- Click Save.
NOTE: For nvarchar and nchar database fields, the N must be prepended to string literals in Where Clauses so Unicode characters will not be lost and the value must have single quotes on either side. This is unnecessary for numeric fields.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.