Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Words and Phrases
| Search for | Example | Results |
|---|---|---|
| A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
|
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Using Boolean Operators
| Search for | Operator | Example |
|---|---|---|
|
Two or more words in the same topic |
|
|
| Either word in a topic |
|
|
| Topics that do not contain a specific word or phrase |
|
|
| Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
| A combination of search types | ( ) parentheses |
|
Validity validation rules
- Each entry must have at least one entry in the Files/Formats field.
- Each entry in the Files/Formats field must be a valid database dictionary name or form name.
- The Field Name must be defined in each database dictionary listed in the Files/Formats array or to the database dictionary associated with the form.
- The data type of the Field Name must be the same for each file listed in the Files/Formats array or for the file associated with the form.
- The Unique ID is a user-provided value that uniquely identifies the record.
- The unique key of the validity table contains the following fields: field.name, sequence, and filename. Each combination of the Field Name, Sequence, and each element of the Files/Formats array in the validity record must also be unique within the validity table. This check is performed before the record is added or updated. If duplicates are found, the add/update action is not performed, and the following message is displayed: This record contains an invalid duplicate key.
- The value in the Alt Application field must be a valid RAD application.
- The Secondary File Query Filename value must be a valid database dictionary name.
- The Lookup Fields must be defined to the Secondary Query Filename and their data types must be the same as the Field Name.
- The Val Fields must be defined to the Files/Format file and their data types must be the same as the Field Name.
- The Record list format must be a valid form name.
- The value in the No Recs Option field must be the word Proceed, or Return. If neither is selected the system defaults to Proceed when the record is validated.
Related concepts
Data validation
Look-up processing
Related tasks
Display value summary details
Display range summary details
Create validity table definitions
Add field-level definitions
Add value definitions
Add range definitions
Validate the validity definitions
Delete an entire validity record
Delete a single value or range definition
Delete value or range definitions from a table
Print a detailed report of an entire validity record
Validate fields during record processing
Create a validity lookup option in Format Control
Call validate.fields from Format Control
