ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Displaying the result in a List Box or Combo Box control
  • Extracting information from the result
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Returns the list of full-text indexes for a data file recognized by the HFSQL engine. You can get:
  • the expression of the full-text index,
  • whether the full-text index is sensitive to the case or to the accented characters,
  • the minimum length of indexed words,
  • whether the full-text index supports the HTML or RTF format,
  • whether the full-text index uses a list of stop words
  • whether the full-text index uses a list of synonyms
  • which language is used for the stemming...
Files defined by functions HDeclare, HDeclareExternal and HDescribeFile are taken into account.
Example
// Récupérer les index full-text d'un fichier de données de l'analyse en cours
ListeFullText is string
ListeFullText = HListFullTextIndex(CLIENT, hLstDetail)
// Ajoute la liste des index dans le champ COMBO_COMBO1
ListAdd(COMBO_COMBO1, ListeFullText)
Syntax
<Result> = HListFullTextIndex(<Data file> [, <Path of the WDD file> [, <Password of the WDD file> [, <Options>]]])
<Result>: Character string
List of full-text indexes found in the specified data file. The descriptions of each full-text index are separated by CR characters (Carriage Return). The result is more or less detailed depending on the constant used:
hLstDetail is not specified<Name of full-text index 1> + CR + <Name of full-text index 2 + CR + ...
The result is identical with the hLstSorted constant.
hLstDetail is specified
  • Before version 20: <Name of full-text index 1> + TAB + <Formula> + NL + ...
  • After version 20: <Full-text index name 1> + TAB + <Formula> + TAB + <Case sensitivity> + TAB + <Accent sensitivity> + TAB + <Minimum length> + TAB + <HTML handling> + TAB + <RTF handling> + TAB + <Stop words> + TAB + <Synonyms> + TAB + <Stemming> + CR + ...
Where:
  • <Full-text index name X>: full-text index entry name
  • <Formule> Component: list of items making up the full-text index. The items are separated by the "+" character.
  • <Sensible à la casse>: "1" if the full-text index is case sensitive, "0" otherwise.
  • <Accent Sensitive>: "1" if the full-text index is accent-sensitive, "0" otherwise.
  • <Longueur minimale> minimum length of indexed words (0 if all words are indexed).
  • <HTML Management>: "1" to prevent HTML tags from being indexed, "0" to not manage HTML.
  • <RTF Management>: "1" for RTF tags not to be indexed, "0" not to manage RTF.
  • <Stop Words>: "1" if the full-text index uses a stop word list, "0" otherwise.
  • <Synonyms>: "1" if the full-text index uses a list of synonyms, "0" otherwise.
  • <Racinisation> integer corresponding to the language used for rootization, "0" if the full-text index does not use rootization.
<Data file>: Character string
Name of the data file for which the full-text indexes must be listed.
<Path of the WDD file>: Optional character string
Full path of analysis (.WDD file) where the data file is described. If this parameter is not specified or is an empty string (""), the data file is searched for in the current analysis.
<Password of the WDD file>: Optional string or Secret string
Password defined for the analysis. If no password is defined, this parameter must be an empty string ("").
New in version 2025
Secret strings: If you use the secret string vault, the type of secret string used for this parameter must be "ANSI or Unicode string".
To learn more about secret strings and how to use the vault, see Secret string vault.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of list to perform:
hLstDetailDetailed information.
hLstNormal
(default value)
Non-detailed information.
hLstSortedSorts the list in ascending order.
Remarks

Displaying the result in a List Box or Combo Box control

<Result> can be directly assigned to a List Box or Combo Box control by ListAdd. Each row will contain the name of one of the full-text indexes found.

Extracting information from the result

To extract information from the detailed result, it is recommended to use ExtractString.
Component: wd300hf.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help