PunctuationSensitive (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Search performed on a "punctuation-sensitive" item

Configuring the different search options for an item

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

This content has been translated automatically. Click here to view the French version.

Search performed on a "punctuation-sensitive" item
Configuring the different search options for an item

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL properties

PunctuationSensitive (Property)

In french: SensiblePonctuation

Available only with these kinds of connection

The Property SensitivePunctuation allows you to set the parameters for taking punctuation into account (comma, full stop, etc.) in the various searches carried out in the field (with the HReadSeek, HReadSeekFirst and HReadSeekLast functions 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).

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store apps mode.

New in version 18

This property is now available in Windows Store apps mode.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Example

// Define the management mode of punctuation 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 (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.

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

<Item>.PunctuationSensitive = <New management mode>

<Item>: 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 punctuation during searches, use the Property PunctuationSensitive.