ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL
  • 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
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Partial indexing of memos
ODBCOLE DBNot available with these kinds of connection
Overview
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:
  1. In the data model editor, display the description of the items found in a data file containing a text memo.
  2. Select the item associated with a text memo.
  3. In the right section of screen, you have the ability to specify whether the memo must be a key or not:
  4. 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.
  5. Validate.
  6. 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 nameEffect
NameItem name
AccentSensitiveTake the accented characters into account when performing searches on the item.
CaseSensitiveTake the case (uppercase/lowercase characters) into account when performing searches on the item.
PunctuationSensitiveTake the punctuation characters (comma, period, ...) into account when performing searches on the item.
SizeSize of a text item (character string, text memo, character).
KeySizeSize of the section to index in the text memo.
TypeIdentifies and modifies the type of an item.
KeyTypeCharacteristics of a key item.
SortTypeCharacteristics 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)
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/30/2023

Send a report | Local help