PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • 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
..CaseSensitive is used to configure the management mode of case (uppercase/lowercase characters) 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 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
Name..CaseSensitive = True
...
// Validates the file description
HDescribeFile(Orders)
Syntax

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

<Result> = <File Name>.<Item Name>..CaseSensitive
<Result>: Boolean
  • True if the case is taken into account by the searches performed on this item,
  • 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.
  • 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 Name>..CaseSensitive = <New Management Mode>
<Item Name>: 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

Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment