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
Update multiple records using a variable value
Applies to User Roles:
Example: Change the email address for all Advantage contacts records for people located in North America to follow the pattern: firstname.lastname@example.org.
To update multiple records with a variable value:
- Open the contacts form in Database Manager. Ensure that you select the Administration Mode check box.
- Enter the desired value in the Company input field. For this example, select advantage from the Company list.
- Enter the desired value in the Location input field.
For this example, type
- Click Search.
Database Manager performs the full search and displays the Record List of matching records, if any, in the contacts form.
- Select Mass Update from the tool bar to start the process of updating the records listed.
Database Manager re-displays the initial form with different option buttons.
- Do not enter values in any field. Click Complex Update.
Database Manager displays the Mass Add/Update Instruction screen.
- Enter the following assignment statement in the Instructions for action on EACH RECORD input field, as shown:
Statement Purpose email in $file = first.name in $file + “.” + last.name in $file + “@advantage.com” Sets the email address to email@example.com.
The system executes this instruction for each record updated. Then it returns terminal control to you, and displays the message “nnn records updated in the contacts file”, where nnn is the number of records updated.
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