PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • How to describe a full-text index by programming?
  • List of HFSQL properties used to describe a full-text index 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
HDescribeFullTextIndex (Function)
In french: HDécritIndexFullText
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Describes a full-text index of data file created by programming.
After the call to HDescribeFullTextIndex:
  • The item can be handled like any analysis item.
  • The item description cannot be modified anymore.
  • The description variable of item is re-initialized. A new index description can be performed.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
MyFullTextIndex is Description of FullTextIndex
 
// Describe the full-text index
MyFullTextIndex..MinimumLength = 4
MyFullTextIndex..Name = "MyFullTextIndex"
MyFullTextIndex..Items = "LASTNAME+FIRSTNAME"
MyFullTextIndex..AccentuationSensitive = True
MyFullTextIndex..CaseSensitive = False
 
HDescribeFullTextIndex(AFile, MyFullTextIndex)
Syntax
<Result> = HDescribeFullTextIndex(<Data file> , <Full-text index>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HErrorInfo is used to identify the error.
<Data file>: Character string (with or without quotes)
Name of HFSQL data file (described by HDescribeFile).
<Full-text index>: FullTextIndex Description variable
Name of FullTextIndex description variable containing the description of full-text index.
Remarks

How to describe a full-text index by programming?

To describe a full-text index by programming, you must:
  1. Use the File description, Item description, Link description and FullTextIndex description variables (if necessary).
  2. Describe the characteristics of data file, items, links and full-text indexes via the HFSQL properties.
  3. Define the description of items with HDescribeItem.
  4. Define the description of full-text indexes with HDescribeFullTextIndex.
  5. Define the description of data file (HDescribeFile) and links (HDescribeLink).

List of HFSQL properties used to describe a full-text index by programming

The following properties are available in read/write.
AccentuationSensitive..AccentuationSensitive is used to configure the management mode of accented characters in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
CaseSensitive..CaseSensitive is used to configure the management mode of case (uppercase/lowercase characters) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Items..Items is used to configure the different items included in a full-text index.
ManageHTML..ManageHTML is used to configure the HTML management mode in a full-text index.
ManageRTF..ManageRTF is used to configure the management mode of RTF in a full-text index.
MinimumLength..MinimumLength is used to configure the minimum length of the words to index.
Name..Name is used to find out:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page.
Component : wd250hf.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment