Kbase P17984: Loading delta.df returns case-sensitivity warning
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows 2000
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Loading delta.df returns case-sensitivity warning:
** MODIFY FIELD <field-name> caused a warning **
Can't change case-sensitivity of <field-name> because it is part of an index.
CAUSE:
A character field can be defined as CASE-SENSITIVE or not.
The warning message indicates that the field mentioned was defined as CASE-SENSITIVE or NOT-CASE-SENSITIVE, and the delta.df is trying to change this to the opposite value.
Because the field concerned has been used to define an index, the case-sensitivity can't be changed.
If a field isn't part of an index, then the case-sensitivity can also normally be changed under the Data Dictionary, Field Properties. If the field is part of an index, then the toggle to change the case-sensitivity is greyed out.
FIX:
In order to change the case-sensitivity for that field, the index will need to be deleted. The case-sensitivity can then be changed - run the delta.df again, or change the case-sensitivity toggle under the field properties. Then recreate the index as b=necessary.
Before doing this, be certain that the case-sensitivity should be getting changed for that field, and that this was what was intended with the delta.df.