ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
  • Search performed on a "punctuation-sensitive" item
  • Configuring the different search options for an item
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
PunctuationSensitive (Property)
In french: SensiblePonctuation
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
The PunctuationSensitive property is used to determine if punctuation characters (comma, period, etc.) are taken into account in the different searches performed on the item (with HReadSeek, HReadSeekFirst and HReadSeekLast, for example). You can:
  • Find out whether the searches performed on this item are punctuation-sensitive (item defined in the data model editor or through programming).
  • Define the punctuation management mode for an item (item described through programming).
Example
// Define the punctuation management mode for the Orders.Name item
Name.PunctuationSensitive = True
...
// Validate the data file description
HDescribeFile(Orders)
Syntax

Finding out whether the punctuation is taken into account Hide the details

<Result> = <Data file>.<Item>.PunctuationSensitive
<Result>: Boolean
  • True if the searches performed on this item are punctuation-sensitive,
  • False otherwise.
<Data file>: Character string
Name of the data file used. This name was defined in the data model editor or with the File Description type.
<Item>: Character string
Name of the item used. This name is defined in the data model editor or with the Item Description type.

Defining the punctuation management mode (item described through programming) Hide the details

<Item>.PunctuationSensitive = <New mode>
<Item>: Character string
Name of the item used. This name is defined with the Item Description type.
<New mode>: Boolean
  • True if the searches performed on this item are punctuation-sensitive,
  • False otherwise.
Remarks

Search performed on a "punctuation-sensitive" item

When a search is performed on a "punctuation-sensitive" item, only the sentences with matching punctuation characters will be found. Therefore, if the name of the customer is "Mr.Smith", the search performed on:
  • "Mr.Smith" will find the matching record,
  • "Mr Smith" will find no matching record.

Configuring the different search options for an item

  • To make searches accent-sensitive or insensitive, use the AccentSensitive property.
  • To make searches case-sensitive or insensitive, use the CaseSensitive property.
  • To make searches punctuation-sensitive or insensitive, use the PunctuationSensitive property.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/08/2024

Send a report | Local help