PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

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
KeyType (Property)
In french: TypeClé
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
..KeyType is used to configure the characteristics of a key item. You can:
  • Find out whether an item is key for an item defined in the data model editor or by programming.
  • Define a key item (when the item is described by programming).
Versions 17 and later
iPhone/iPad This property is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone/iPad applications.
iPhone/iPad This property is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Define the characteristics of the Orders.OrdID key
Orders.OrdID..KeyType = hUniqueKey
...
// Validates the file description
HDescribeFile(Orders)
Syntax

Finding out whether an item is key Hide the details

<Characteristic> = <File Name>.<Item Name>..KeyType
<Characteristic>: Integer constant
The characteristics of an item are:
hDuplicatesKeyKey with duplicates. This item can have the same value for several data file records.
hUniqueKeyUnique key. The value assigned to this item will be unique in the data file. No file record will have the same value for this item.
hNotAKeyThe item is not a key.
<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.
WINDEVWEBDEV - Server codeReports and QueriesiPhone/iPadWindows MobileUniversal Windows 10 AppAjaxUser code (UMC)

Defining a key by programming Hide the details

<Item Name>..KeyType = <Type of Key>
<Item Name>: Character string (with or without quotes)
Name of item used. This name was defined by the Item Description type.
<Type of Key>: Integer constant
The characteristics of a key can be:
hDuplicatesKeyKey with duplicates. This item can have the same value for several data file records.
hUniqueKeyUnique key. The value assigned to this item will be unique in the data file. No file record will have the same value for this item.
hNotAKeyThe item is not a key.
See also
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment