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 |
|
- Methods for adding database dictionary records
- Field name requirements
- Create an inactive database dictionary record
- Create an active database dictionary record
- Add a structure to the database dictionary
- Add an alias field
- Add an array
- Add fields to a structure
- Create a database dictionary record by importing RDBMS columns
- Designate unique fields in the array of structures
Add a structure to the database dictionary
Applies to User Roles:
System Administrator
You can add a structure to the database dictionary by using System Definition or by using the Database Dictionary utility. Choose one of the following methods to add a structure.
Note: You must use the Windows client whenever you need to add a new field/key to a database dictionary table.
Add a structure by using System Definition
To add a structure by using System Definition:
- In the System Navigator, click System Definition > Tables > filename > Fields.
- Click New Field.
- Type a name in the Field Name field.
- Click OK. The new field name is now listed in its alphabetical place in the fields list.
- Select the new field from the list, and in the General properties section select Structure in the Data type field, and then specify other general properties and SQL mappings properties for the field.
- Select the structure field from the Fields list, and click New Field.
- Type a name in the Field name field, and click OK. The field is added to the structure.
- Specify general properties, aliases, and SQL mapping properties for the field.
- Repeat steps 6 through 8 to add more fields to the structure.
- Click Save to save the file.
Add a structure by using the Database Dictionary utility
This example illustrates how to add a structure that contains fields for basic employee information. The fields are name, telephone number, and address. These fields will appear on all formats or views of the employee file. Salary, hire.date, review.date, rehire, termination.date, position, and department will appear only on certain forms.
To add a structure by using the Database Dictionary utility:
- From the database dictionary, open the employee file.
- On the Fields tab, place the cursor on the descriptor structure.
- Click New Field/Key.
- In the Name field, type basic.employee.info.
- In the Type field, choose structure from the Type list.
-
Click Add.
You can now add fields within the structure you just created.
- In the Name and Type fields, type a name and select a data type for the first field you want to add to the structure. For example, type person.name and select character.
-
Click Add.
The structure with its first field is added to the Fields tab.
- On the Fields tab, select the structure field you added, and click New Field/Key to add more fields to the structure field. For example, add two more fields named telephone (data type: character) and address (data type: character) .
- Click OK to save your edits.
-
Click SM Alters when you are asked how you want to update the database dictionary.
This returns the message: Record updated in the dbdict file.
Related topics
Forms Designer
Adding a key
Alias fields
Arrays
Arrayed structures
Methods for deleting database dictionary records
Deleting a key
Fields within structures
Methods for updating database dictionary records
Modifying a key
Structures
Access the Database Dictionary utility
Add fields to a structure
Open a database dictionary
Regen a database dictionary