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 a "case-sensitive" item
  • Configuring the 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
CaseSensitive (Property)
In french: SensibleCasse
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
The Property Case Sensitive allows you to set the case sensitivity (upper/lower case) 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 case is taken into account when performing searches 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 mode of case for an item or for a full-text index (when the item or the full-text index is described by programming).
Example
// Define how the case is managed in the Orders.Name item
Orders.Name.CaseSensitive = True
...
// Validate the data file description
HDescribeFile(Orders)
Syntax

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

Result> = <Data file>.<Item>.CaseSensitive
<Result>: Boolean
  • True if the case is 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 case (item described by programming) Hide the details

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

Search performed on a "case-sensitive" item

When a search is performed on a "case-sensitive" item, only the words with matching lowercase/uppercase characters will be found.
Therefore, if the customer name is "Smith":
  • a search performed on "Smith" will find a record,
  • a search performed on "SMITH" will find no record.

Configuring the search options for an item

  • To manage the accented characters during the searches, use AccentuationSensitive.
  • To manage case when searching, use the Property CaseSensitive.
  • To manage the punctuation during the searches, use PunctuationSensitive.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment