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.
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||
|A combination of search types||
- Updating multiple records
Add multiple records using a variable value
Applies to User Roles:
Example: Duplicate all "contacts" records with a company.name value of advantage. Include the same information in each record, except for changing the Company to NewAdvantage, creating sequential user.id values, and creating a Unique key for each record.
Since Contact Name (contact.name) is a Unique key and Employee ID (user.id) is a No Duplicates key in the contacts file, you must assign unique contact.name and user.id values to the new records. For additional information about key type definitions, see the related topics. For this example, suffix the user.id values in the new records with sequential numbers, starting with 1000 (1000, 1001, and so on.)
Note: Mass Add processing statements reference $file to access fields on records in the list. For example, name in $file or 1 in action in $file.
To add records using a variable value:
- Open the form in Database Manager.
Ensure that you select the Administration Mode check box.
For this example, open the following form:
contacts. A blank contacts form opens.
Enter the desired value in the Location field.
For this example, type North America, and then click Search.
Database Manager performs the equal to search and displays the Record List of matching record(s), if any. If the query produces no matching records, Service Manager displays a message.
To display the Mass function buttons, use a query that returns more than one record.
Select Mass Add from the tool bar to start the process of duplicating the records shown in the Record List.
Database Manager displays the Mass Add/Update Instruction screen.
- Type the following assignment statement in the Instructions to be executed ONCE at the beginning of Mass Add/Update input field.
Statement Purpose $sequential.number=1000 Sets the start point for the variable at 1000 and will be executed only once for the entire function.
- Enter the following statements on the Instructions for action on EACH RECORD input fields:
Statement Purpose user.id in $file=“NewAdvantage”+str($sequential.number) Sets the User Id to NewAdvantage with a sequential number as a suffix. $sequential.number+=1 Causes one (1) to be added to all future numbers created from this variable. contact.name in $file=first.name in $file + “ ” + last.name in $file Makes the contact name the same as the first and last name.
Database Manager performs the Mass Add function in the foreground. Your session is devoted to the add task until it is completed. If you are updating a large number of records, this can take a while.
Upon completion, Service Manager returns terminal control to you and displays the following message:<nnn>records added to the contacts file where nnn is the number of records added.
- 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.
- Close the Messages window to return to the contacts form.
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 a literal value
- Add multiple records using a variable value
- Update multiple records using a literal value
- Update multiple records using a variable value
- Avoid invalid duplicate or null key errors
- Delete multiple records