ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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 through programming.
  • 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 was 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>: Item Description variable
Name of the item used. This name was defined by 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: 05/26/2022

Send a report | Local help