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.
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. |
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 |
|
Insert a key between other keys
Applies to User Roles:
System Administrator
Example: Insert the key company between the keys name and operators in a copy of the assignment file.
To insert a key between other key:
- Open the assignment dbdict.
- Make a copy of the assignment dbdict named assignment1.
- Click on the key type of the second key, Nulls & Duplicates in this example, above the operators key.
- Click New.
- In the new key window, select a valid key in the Type field by either typing in the value or selecting it from the drop down menu under the arrow button. Use No Nulls for this example.
- Enter company in the field names array.
- Click Add to add this key to the assignment2 database dictionary record.
The key company now appears after the first key, in the second place in the list, and the operators key has moved down the list of keys in the assignment2 database dictionary record. All other keys are moved down the screen. You can scroll the keys array to view the other keys in the list. - You can now reedit your database dictionary record, update it, or cancel without updating.
You must update your database dictionary record when adding a new key, or the database dictionary record will remain the same. - Press OK once you are finished adding keys to the database dictionary record, to close and automatically update the file. This returns the message Record updated in the dbdict file.
- You can either click OK (regen file) to continue with the regen, click Cancel (F3) to abort the regen and restore the database dictionary record to the version prior to the latest changes, or schedule a time for the file regeneration, using Schedule (clock button).
- To remove the key, select it and click Edit.
- The edit window appears, but ignore the window, and instead click Delete on the main record format.
- The next viable key is displayed, if not modifying this key click OK.
You are returned to the database dictionary record minus the key. - Click OK to save the record.
Related topics
Adding a key
Modifying a key
Deleting a key
Arrays
Structures
Arrayed structures
Alias fields
Methods for updating database dictionary records
Methods for deleting database dictionary records
Open a database dictionary
Copy a database dictionary and data records
Add a key as the first key
Add keys to bottom of the key list
Modify keys: Nulls and duplicates to unique
Delete a key
Access the Database Dictionary utility
Regen a database dictionary