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.
|A single word
|Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
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.
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
cat ^ mouse
|A combination of search types
( ) parentheses
- Modifying a Key
Modify keys: Nulls and duplicates to unique
Applies to User Roles:
You can modify keys by using System Definition or by using the Database Dictionary utility. Choose one of the following methods to modify keys.
Modify keys by using System Definition
To modify keys by using System Definition:
- From the System Navigation, click System Definition > Tables > Database Definition > Keys > key name
- Right click Edit.
- Make your changes.
- Click OK.
- Right click Save on the Database Definition node to save your changes.
Modify keys by using the Database Dictionary utility
Example: Change the key type for operators in a copy of the assignment file from Nulls & Duplicates to Unique. If data already exists in the file, ensure that a unique value also exists in the operator field for every record in the file. If this condition is not met, you will then have to update each record individually or perform a Mass Update.
To modify keys by using the Database Dictionary utility:
- Open the assignment dbdict.
- Make a copy of the assignment dbdict named assignment2.
- Position the cursor on the key type Nulls & Duplicates above the key field operators.
- Click Edit.
- In the Type field, type:
- Click OK to close the window and commit the changes to the file.
- You can now reedit your database dictionary record, update it, or cancel without updating.
- Click OK to close and automatically update the file.
This returns the message Record updated in the dbdict file.
Open a database dictionary
Copy a database dictionary only
Add a key as the first key
Insert a key between other keys
Add keys to bottom of the key list
Delete a key
Open a database dictionary
Access the Database Dictionary utility
Regen a database dictionary