Progress
Database Design
Guide
Progress Defaults
The default rules defined by the Progress 4GL are as follows:
- The LETTER attribute is assigned to all characters defined as letters in the current language. In English, the uppercase characters A-Z and the lower-case characters a-z are defined as letters.
- The DIGIT attribute is assigned to the characters 0-9.
- The following characters are assigned the USE_IT attribute: dollar sign ($), percent sign (%), number sign (#), at symbol (@), and underline ( _ ).
- The following characters are assigned the BEFORE_DIGIT attribute: period (.), comma (,), and hyphen (-). This means, for example, “12.34" is one word, but “ab.cd” is two words.
- The IGNORE attribute is assigned to the apostrophe (’). This means, for example, the word John’s is the same as Johns.
- The TERMINATOR attribute is assigned to all other characters.
These rules apply to both the text in a word index field and text in a CONTAINS clause. For example, if you type “John’s” in a CONTAINS clause, it is treated the same as “Johns”. If you type “8:30pm” it is treated as two words: 8 and 30pm. Therefore, a record containing the string “8:30pm” will be found, but so could a record containing “8 Capital St. at 7:30pm.” As with indexes, separators and terminators are ignored for the second part of the CONTAINS clause. This means that the string entered in the database matches the string entered after the CONTAINS clause.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |