Kbase P26984: How to use Data Dictionary to adjust a field's SQL Width. A step-by-step approach.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/25/2010 |
|
Status: Verified
GOAL:
How to use Data Dictionary to adjust a field's SQL Width. A step-by-step approach.
GOAL:
Step-by-step guide to use Data Dictionary to adjust a field's SQL Width
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
GUI: To adjust the field width in graphical mode:
1) Access the data dictionary and connect to the database.
2) Select a table.
3) Choose Options> SQL Properties> Adjust Field Width from the menu bar...
4) Progress displays the Adjust Field Width dialog box.
5) Select the name of the field whose width you want to adjust, click its width setting, and make the adjustment.
6) Repeat Step 5 for any other fields.
7) Choose Save, and then choose OK.
CHUI: To adjust the field width in character mode:
1) Access the data dictionary and connect to the database.
2) Choose Schema> SQL Properties. A table name appears in the Table Name field, which is followed by a list of additional table names.
3) Choose the table you want; the name automatically appears in the Table Name field.
4) Press ENTER to open the table. The width of the first field in the field name listing is highlighted.
5) Select the name of the field whose width you want to adjust, click its width setting, and make the adjustment.
6) Repeat Step 5 for any other fields.
7) Choose Save, then press ENTER.
8) Press F4, and then choose Apply Changes.