Progress
Basic Database
Tools
Adjusting the SQL Field Width
The SQL Field Width property allows the 4GL client to modify the field width so that the SQL-92 client will have the proper size to work with. If you do not adjust the setting, the SQL-92 client uses the default width property.
To adjust the field width in character mode, make sure you are connected to a database and follow these steps:
- Access the Data Dictionary.
- Choose Schema
SQL Properties. A table name appears in the Table Name field, which is followed by a list of additional table names.
- Choose the table you want; the name automatically appears in the Table Name field.
- Press ENTER to open the table. The width of the first field in the field name listing is highlighted.
- Select the name of the field whose width you want to adjust, click its width setting, and make the adjustment.
- Repeat Step 5 for any other fields.
- Choose Save, then press ENTER.
- Press F4, then choose Apply Changes.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |