Progress
DataServer for
Microsoft SQL Server
Guide
Modifying Field-level Information
To modify information in the schema holder at the field level, follow these steps:
- Access the Data Dictionary, if not already showing, choose the Fields button. The following Fields list appears.
![]()
- Select a table from the Tables list.
- Select a field from the Fields list.
- Choose the Field Properties button. The following dialog box appears:
![]()
You can enter Progress information at the field level, such as a validation expression or a validation message.
The Data Dictionary displays the standard SQL Server™ names for data types and not the native ODBC data source names. Using the Data Dictionary, you can make the following changes:
- Change the data type or the format in which Progress displays the data. For example, choose the SQL Server™ smallint data type, which in turn maps to the Progress INTEGER data type. However, you can change the SMALLINT mapping to the Progress DECIMAL or LOGICAL data type instead. (See the "Data Types" section in "Programming Considerations," for information on optional settings for data types.)
NOTE: You cannot create fields or add mandatory or extent properties to them.- For CHARACTER fields that are not indexed, you can change the case sensitivity.
- Choose the DataServer button to view the field name and position as stored in the data source. A dialog box similar to the following appears:
NOTE: You cannot change data source information using the Data Dictionary. For example, the Cust–num field is named Cust_num in the demonstration database.
![]()
- Choose OK.
NOTE: You can override field-level validation expressions in your application by including the appropriate Progress 4GL statement.- When you are done making changes, choose OK to return to the Data Dictionary main window.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |