Progress
ADM 2 Guide
Data Dictionary Validation
As you might expect, Data Dictionary validation is simply the validation expression (and accompanying validation message) defined in the Data Dictionary. The temp–table columns inherit this validation for each column that maps to a single database field. Client objects can query it using the columnValExp and columnValMsg functions; for example, you might do this at design time to include Data Dictionary validation in the generated code for a non-Progress visualization.
Note that SmartDataBrowsers and SmartDataViewers include the same field definition list as the SmartDataObject. In this way, these objects automatically inherit the format, validation expression, and other field attributes of each field in the RowObject, as defined in the SmartDataObject. This field validation can be performed in the visualization even without a database connection available at run time (in the event that the application is distributed using AppServer), as long as the field validation does not require database lookups (CAN–FIND, and so forth). Because of this restriction, the column definition dialog box (which appears when you build a SmartDataObject) includes a toggle box that you can turn off to prevent the RowObject field from inheriting the field validation for the database field from which that column is derived. You should normally turn off this toggle box if the Data Dictionary validation requires a database lookup and the client might be run without a database connection of its own to satisfy that lookup.
The Data Dictionary validation is not automatically executed in the SmartDataObject itself. It normally occurs in the SmartDataViewer or SmartDataBrowser when saving changes to an entire row.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |