Progress
DataServer
for ODBC Guide
Modifying Field-level Information
To modify information in the schema holder at the field level, follow these steps:
- Access the Data Dictionary, if you are not already there, and choose the Fields button. The Tables 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 ODBC SQL 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, the Microsoft SQL Server smallint data type maps to the ODBC SQL SQL_SMALLINT data type, which in turn maps to the Progress INTEGER data type. However, you can change the SQL_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 ODBC data source. A dialog box similar to the following appears:
NOTE: You cannot change ODBC 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 |