Kbase 21060: Error 87 When Running Update/Add Table Definitions Utility
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/1/2002 |
|
Status: Unverified
FACT(s) (Environment):
DataServers
SYMPTOM(s):
** Input value: <input> should be <yes
o>. (87)
Error 87 is encountered when running an Update/Add Table Definitions against a schema holder containing logical fields with an initial value other than 'yes' or 'no'.
This was logged as bug number 20010607-013, and is fixed in the latest patches for Progress Version 9.1C.
CAUSE:
In the Progress Data Dictionary, logical fields can be created with an initial value other than 'yes' or 'no' and a format other than 'yes
o'. However, when an attempt is made to update that logical field through the Update/Add Table Definitions utility, the Data Dictionary fails to recognize those atypical initial values as valid.
FIX:
A recommended workaround for prior releases is before running Update/Add Table Definitions;
1. Go into the Data Dictionary and connect to the schema holder.
2. Modify the logical field(s) in question by changing the field Initial Value to either 'yes' or 'no'.
Entering 'yes' is equivalent to selecting the first value from the Format field and setting it as the default, whereas entering 'no' is equivalent to selecting the second value.
3. Then run Update/Add Table Definitions.