ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
KeySize (Property)
In french: TailleClé
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
The KeySize property is used to set the characteristics of a text memo key item. You can:
  • Get the size of the indexed part of the memo for an item defined in the data model editor or programmatically.
  • Define the size of the indexed part of the memo (when the item is described through programming).
Example
MyMemoIndex is Item Description
MyMemoIndex.Name = "Comments"
MyMemoIndex.Type = hItemTextMemo
MyMemoIndex.KeyType = hUniqueKey
MyMemoIndex.SortType = hIncreasing
MyMemoIndex.AccentSensitive = False
MyMemoIndex.CaseSensitive = False
MyMemoIndex.PunctuationSensitive = False
MyMemoIndex.KeySize = 50
HDescribeItem(Book, MyMemoIndex)
Syntax

Getting the size of the indexed part of the memo Hide the details

<Size> = <Data file>.<Item>.KeySize
<Size>: Integer
Number of characters that will be indexed in the text memo.
<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 size of the indexed part of the memo Hide the details

<Item>.KeySize = <Indexed size>
<Item>: Type variable Field description
Name of the item used. This name is defined with the Item Description type.
<Indexed size>: Integer
Size of indexed part of memo, expressed in number of characters.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/06/2024

Send a report | Local help