PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • 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 by programming
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
Versions 15 and later
Native Accesses This feature is available for the Native Accesses.
New in version 15
Native Accesses This feature is available for the Native Accesses.
Native Accesses This feature is available for the Native Accesses.
Versions 17 and later
WINDEV MobileiPhone/iPad This feature is now available for the iPhone/iPad applications.
New in version 17
WINDEV MobileiPhone/iPad This feature is now available for the iPhone/iPad applications.
WINDEV MobileiPhone/iPad This feature is now available for the iPhone/iPad applications.
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 by 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: not key, unique key or key with duplicates.
    • the browse 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 by programming

To implement the indexing of text memos when describing a data file by 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
AccentuationSensitiveTake 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..AccentuationSensitive = False
MyMemoIndex..CaseSensitive = False
MyMemoIndex..PunctuationSensitive = False
MyMemoIndex..KeySize = 50
HDescribeItem(Book, MyMemoIndex)
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment