PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
PunctuationSensitive (Property)
In french: SensiblePonctuation
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
..PunctuationSensitive is used to configure the management mode of punctuation (comma, dot, etc.) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example). You can:
  • Find out whether the punctuation is taken into account by the searches performed on this item (defined in the data model editor or defined by programming).
  • Define the management mode of the punctuation for an item (when the item is described by programming).
Example
// Define the management mode of punctuation for the Orders.Name item
Name..PunctuationSensitive = True
...
// Validates the file description
HDescribeFile(Orders)
Syntax

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

<Result> = <File Name>.<Item Name>..PunctuationSensitive
<Result>: Boolean
  • True if the searches performed on this item are sensitive to punctuation,
  • False otherwise.
<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.
<Item Name>: 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.

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

<Item Name>..PunctuationSensitive = <New Management Mode>
<Item Name>: Character string (with or without quotes)
Name of item used. This name was defined by the Item Description type.
<New Management Mode>: Boolean
  • True if the punctuation must be taken into account by the searches performed on this item,
  • 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 manage the accented characters during the searches, use ..AccentuationSensitive.
  • To manage the case during the searches, use ..CaseSensitive.
  • To manage the punctuation during the searches, use ..PunctuationSensitive.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment