|
|
|
|
- Overview
- How to partially index the text memos?
- Implementing the indexing of text memos in the data model editor
- Implement the indexing of text memos through programming
Partial indexing of memos
Not available with these kinds of connection
You have the ability to index the content of a text memo item. The size of the text memos being quite important, the mechanism of partial indexing is used for the memos. The partial indexing of the text memos is used to define the number of characters that will be indexed in the text memo. This mechanism is used to optimize the size of the indexes and the search speed. For example, if the content of an invoice (found in a text memo) is indexed, you will not necessarily have to index for each invoice the three pages of general sales conditions that follow the useful data.
How to partially index the text memos? The indexing of text memos can be performed: - in the data model editor (for the data files described in the analysis)
- in WLanguage for the data files created through programming.
Implementing the indexing of text memos in the data model editor To implement the indexing of text memos: - In the data model editor, display the description of the items found in a data file containing a text memo.
- Select the item associated with a text memo.
- In the right section of screen, you have the ability to specify whether the memo must be a key or not:
- Specify:
- the type of partial key: non-key, unique key, key with duplicates or primary key.
- the iteration direction: ascending or descending.
- the size of the indexed part of the memo. This size must be specified in number of characters.
- whether the search must be sensitive to the case, to the accented characters and to the space characters.
- Validate.
- Generate the analysis. If data files have been already used, an automatic modification of the data files is performed.
Implement the indexing of text memos through programming To implement the indexing of text memos when describing a data file through programming, all you have to do is use the available WLanguage properties on the items to specify the characteristics of text memo key. | | Property name | Effect |
---|
Name | Item name | AccentSensitive | Take the accented characters into account when performing searches on the item. | CaseSensitive | Take the case (uppercase/lowercase characters) into account when performing searches on the item. | PunctuationSensitive | Take the punctuation characters (comma, period, ...) into account when performing searches on the item. | Size | Size of a text item (character string, text memo, character). | KeySize | Size of the section to index in the text memo. | Type | Identifies and modifies the type of an item. | KeyType | Characteristics of a key item. | SortType | Characteristics of the sort on an item. |
Example: MyMemoIndex is Item Description MyMemoIndex.Name = "Comments" MyMemoIndex.Type = hItemTextMemo MyMemoIndex.KeyType = hUniqueKey MyMemoIndex.SortType = hIncreasing MyMemoIndex.AccentSensitive = False MyMemoIndex.CaseSensitive = False MyMemoIndex.PunctuationSensitive = False MyMemoIndex.KeySize = 50 HDescribeItem(Book, MyMemoIndex)
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|