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||
- Database dictionary
- Database dictionary records
- Making database dictionary changes
- Database dictionary data types
- Alias fields
- Access the database dictionary utility
- Enable DDL logging of database dictionary changes
- Open a database dictionary
- Copying a database dictionary
- Methods for adding database dictionary records
- Methods for deleting database dictionary records
- Methods for updating database dictionary records
- Renaming a database dictionary
- Resetting a database table
Open a database dictionary
Applies to User Roles:
You can open a database dictionary (dbdict) from Forms Designer, by using System Definition, or by using the Database Dictionary utility. Choose one of the following methods to open a dbdict.
Open a dbdict by using System Definition
To open a dbdict by using System Definition:
From the System Navigator, click System Definition > Tables > <dbdict_name>.
Note: The files are listed alphabetically. You can type the first letter of a table name to jump to that alphabetic section. For example, type
oto jump to the oncall table.
- Click the plus (+) next to the file name to open the folder.
- Click the plus (+) next to the Fields or Keys folder to open it.
- Double-click a field or key to edit it.
Open a dbdict when using Forms Designer
To open a database dictionary when using Forms Designer:
- Open an associated form using Forms Designer. For this example, access the contacts form.
- Select System Definition from the More Actions menu. The dbdict for that form opens.
Open a dbdict by using the Database Dictionary utility
This example opens the contacts dbdict.
To open a database dictionary by using the Database Dictionary utility:
- Click Tailoring > Database Dictionary.
Type the name of the dbdict file you want to edit into the File Name field.
For this example, type: contacts.
The dbdict definition record(s) with that name opens. If more than one file is displayed, select the correct file to view it.
To see more fields, use the scroll bar on the right of the field names list. To see more keys, use the scroll bar on the right of the keys list.
Copying a database dictionary
Renaming a database dictionary
Resetting the database and all records
Adding a key
Methods for updating database dictionary records
Modifying a key
Methods for deleting database dictionary records
Deleting a key