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 |
|
Avoid invalid duplicate or null key errors
Applies to User Roles:
System Administrator
Records cannot have duplicate Unique or No Duplicates keys. This example shows one such error and how to fix it.
To handle an invalid duplicate of NULL key error:
-
Open the form in Database Manager. For this example, open the following form:
contacts
. Be sure to select the Administration Mode check box.A blank contacts form opens.
- Type NewAdvantage in the Employee ID field., and then click Search.
-
Select Mass Update. from the tool bar to begin updating the records shown in the Record List.
Database Manager displays the initial form again.
- On the displayed form, type NewAdvantage in the Contact Name field.
-
Click Simple Update.
- The system accepts the first update, because the contact name is unique.
- The system rejects the second update, since changing it would create a duplicate contact name.
Database Manager opens the record for modification and displays an error message.
-
Click View Messages to check the messages for errors.
- A blue icon indicates a required action.
- A yellow icon indicates an informational or warning message.
- A red icon indicates an error message.
- At this point, there are several options concerning the outcome of this process.
- Enter a unique key and click Retry for each item on the list separately, to cause Service Manager to reexecute everything, including the Format Control.
- Click Skip to cause Service Manager to skip the record.
- Click Force to cause Service Manager to update the record with the information you entered, regardless of Format Control.
For this example, modify the Contact Name field value to make it unique for each item. (NewAdvantage2, NewAdvantage3, NewAdvantage4, and so on.)
If the update was successful, Service Manager displays the following message: “<n>records updated in the contacts file.”
-
Type NewAdvantage in the Employee ID (user.id) field, and then click Search.
Database Manager displays the records you have just added in a record list.
The Employee ID values consist of Advantage + 1000, 1001, and so on, and the Contact Name values the first and the last names. The original records listed before the Mass Add remain in the contacts file, with no changes to the original data.
The topics below comprise an example of how to use multiple-record functions. Follow the steps in this order. If you skip a step, the example will not work.
- Add multiple records using Mass Add with a literal value
- Add multiple records using Mass Add with a variable value
- Update multiple records using a literal value
- Update multiple records using a variable value
- Avoid invalid or null key errors
- Delete multiple records
Related topics
Determine the number of records in a record list