PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Properties specific to the description of full-text indexes
  • How to describe the data files 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
FullTextIndex description (Type of variable)
In french: Description d'IndexFullText (Type de variable)
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
A FullTextIndex description variable is used to describe one or more full-text indexes through programming. The characteristics of these indexes can be defined using different WLanguage properties
To add the description of this index into the description of a data file, use HDescribeFullTextIndex. The "FullTextIndex Description" variable is reinitialized and it can be used to describe another full-text index through programming.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
UnFichier is File Description
UneRubrique is Item Description
MonIndexFullText is IndexFullText Description
CLIENT is Data Source
 
// Description du fichier "CLIENT"
UnFichier.Name = "CLIENT"
UnFichier.Type = hFileNormal
UnFichier.FicCryptMethod = hEncryptionStandard
 
// Description de la rubrique "NOM"
UneRubrique.Name = "NOM"
UneRubrique.Type = hItemText
UneRubrique.Size = 40
UneRubrique.KeyType = hDuplicatesKey
HDescribeItem(UnFichier, UneRubrique)
 
// Description de la rubrique "PRENOM"
UneRubrique.Name = "PRENOM"
UneRubrique.Type = hItemText
UneRubrique.Size = 40
HDescribeItem(UnFichier, UneRubrique)
 
// Description de l'index full-text
MonIndexFullText.MinimumLength = 4
MonIndexFullText.Name = "MonIndexFullText"
MonIndexFullText.Items = "NOM+PRENOM"
MonIndexFullText.AccentSensitive = True
MonIndexFullText.CaseSensitive = False
HDescribeFullTextIndex(UnFichier, MonIndexFullText)
 
// Valide la description du fichier
HDescribeFile(UnFichier)
// Création du fichier Client (reconnu car déclaré comme source de données)
HCréation(CLIENT)
// Création d'un enregistrement
CLIENT.NOM = "Dupont"
CLIENT.PRENOM = "André"
HAdd(CLIENT)
// Création d'un enregistrement
CLIENT.NOM = "Dupont"
CLIENT.PRENOM = "Robert"
HAdd(CLIENT)
Syntax

Declaring one or more FullTextIndex descriptions Hide the details

<Variable name> is FullTextIndex description
<Variable name 1>, <Variable name 2> are FullTextIndex descriptions
<Variable name>:
Name of the "hFullTextIndex Description" variable to declare.
Remark: The a and an keywords are optional: they provide better readability.

Describing a "FullTextIndex Description" variable Hide the details

To describe a "FullTextIndex Description" variable:
Use the WLanguage properties specific to the descriptions of full-text indexes. For more details, see remarks.

To validate the description of a "FullTextIndex Description" variable:
Use HDescribeFullTextIndex.
Remarks

Properties specific to the description of full-text indexes

The table below presents the properties specific to the description of full-text indexes:
NameType usedEffect
ManageHTMLBooleanConfigures the management mode of the HTML format in a full-text index.
ManageRTFBooleanConfigures the RTF management mode in a full-text index.
MinimumLengthIntegerUsed to define and find out the minimum length of the words to index.
Versions 20 and later
StopWord
New in version 20
StopWord
StopWord
Character stringUsed to define the empty words not to index.
NameCharacter stringMandatory property used to define and find out the name of the full-text index item.
Versions 20 and later
Option
New in version 20
Option
Option
Integer constantUsed to define specific options on the full-text index item.
This property can correspond to:
  • the hftPunctuationUnicode constant to take into account the specific features of the Unicode punctuation.
  • the hftPunctuationSimple constant not to take into account the specific features of the Unicode punctuation.
Versions 20 and later
Stemming
New in version 20
Stemming
Stemming
Integer constantMandatory property used to define the language in which the stemming must be performed.
ItemsCharacter stringUsed to define and find out the different items included in the full-text index.
AccentSensitiveBooleanUsed to define and find out whether the punctuation (comma, dot, ...) is taken into account in the searches performed on the item
CaseSensitiveBooleanUsed to define and find out whether the case (uppercase/lowercase characters) is taken into account in the searches performed on the item.
Versions 20 and later
Synonym
New in version 20
Synonym
Synonym
Character stringUsed to define the synonyms taken into account during the indexing.

How to describe the data files through programming?

To describe the data files through programming, you must:
  1. Declare the variables of type "File Description", "Item Description", "FullTextIndex Description" and "Link description" (if necessary).
  2. For each data file:
  3. If necessary, describe the characteristics of the links using HFSQL properties.
  4. If necessary, validate the description of each link (HDescribeLink).
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment