PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
Items (Property)
In french: Rubriques
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
..Items is used to configure the different items included in a full-text index. You can:
  • Find out the different items of a full-text index (defined in the data model editor or by programming).
  • Define the different items of a full-text index (when the full-text index is described by programming).
Versions 17 and later
iPhone/iPad This property is now available for the iPhone and iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone and iPad applications.
iPhone/iPad This property is now available for the iPhone and iPad applications.
Example
// Describe the full-text index
MyFullTextIndex..MinimumLength = 4
MyFullTextIndex..Name = "FullTextIndex1"
MyFullTextIndex..Items = "LASTNAME+FIRSTNAME"
MyFullTextIndex..AccentuationSensitive = True
MyFullTextIndex..CaseSensitive = False
HDescribeFullTextIndex(AFile, MyFullTextIndex)
...
Syntax

Finding the expression of a full-text index Hide the details

<Index Expression> = <File Name>.<Name of Full-Text Item>..Items
<Index Expression>: Character string
Name of the different items included in the full-text index. These names of items are separated by the "+" character.
<File Name>: Character string (with or without quotes)
Name of data file used. This name was defined in the data model editor or by the File Description type.
<Name of Full-Text Index>: Character string (with or without quotes)
Name of full-text index used. This name was defined in the data model editor or by the FullTextIndex Description type.

Defining the expression of a full-text index Hide the details

<Name of Full-Text Index>..Items = <New expression>
<Name of Full-Text Index>: Character string (with or without quotes)
Name of full-text index used. This name was defined by the FullTextIndex Description type.
<New expression>: Character string (with quotes)
Name of the different items included in the full-text index. These names of items are separated by the "+" character.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment