PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • Search performed on an "accent-sensitive" item
  • Configuring the different search options for an item
  • Limits
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
AccentuationSensitive (Property)
In french: SensibleAccentuation
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
The Property SensitiveAccentuation allows you to set the accentuation in the different searches performed on the topic or on the full-text index (with the HReadSeek, HReadSeekFirst and HReadSeekLast functions for example). You can:
  • Find out whether the accented characters are taken into account in the searches performed on this item (or on this full-text index). The item or the full-text index have been defined in the data model editor or by programming.
  • Define the management of accented characters for an item or for a full-text index (when the item or the full-text index is described by programming).
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store apps mode.
Universal Windows 10 App This property is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Define how the accented characters are managed in Orders.Name
Name.AccentuationSensitive = True
...
// Validate the data file description
HDescribeFile(Orders)
Syntax

Finding out whether the accented characters are taken into account Hide the details

Result> = <Data file>.<Item>.AccentuationSensitive
<Result>: Boolean
  • True if the accented characters are taken into account by the searches performed on this item,
  • False otherwise.
<Data file>: 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.
<Item>: Character string (with or without quotes)
  • Name of item used. This name was defined in the data model editor or by the Item description type.
  • Name of full-text index used. This name was defined in the data model editor or by the FullTextIndex description type.

Defining the management mode of accented characters (item described by programming) Hide the details

<Item>.AccentuationSensitive = <New management mode>
<Item>: Character string (with or without quotes)
<New management mode>: Boolean
  • True if the accented characters must be taken into account by the searches performed on this item,
  • False otherwise.
Remarks

Search performed on an "accent-sensitive" item

When a search is performed on an "accent-sensitive" item, only the words with matching accented characters will be found. Therefore, if the customer name is "Renée", the search performed on:
  • "Renée" will find the record,
  • "Renee" will not find the record.

Configuring the different search options for an item

  • To manage emphasis during searches, use the Property AccentuationSensitive.
  • To manage the case during the searches, use CaseSensitive.
  • To manage the punctuation during the searches, use PunctuationSensitive.

Limits

Property AccentuationSensitive must not be used on a Numeric field or a compound key. Otherwise, an incorrect result may be returned.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment