Kbase P120651: Will unique index limit null values being entered as unique values?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/06/2009 |
|
Status: Verified
GOAL:
Will unique index limit null values being entered as unique values?
GOAL:
Indexes and unknown values
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Progress 8.x
Progress 7.x
FIX:
If an index contains an unknown value (?), Progress sorts that value higher than any other value. When you define a unique index, Progress ensures its uniqueness. For example, if cust-num is a unique index, and there is already a cust-num with a value 10, Progress does not allow you to create a cust-num with the value 10. However, Progress does not prohibit users from entering any number of records with unknown values in index fields. You can prevent users from doing this by making the unique index fields mandatory.