AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Propiedades WLanguage / Propiedades HFSQL
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
KeyType (Property)
 
HFSQL ClassicHFSQL Client/ServerDisponible solo con estos tipos de conexión
The KeyType property is used to set the characteristics of a key item. You can:
  • Determine if an item is key for an item defined in the data model editor or programmatically
  • Define a key item (only for items defined programmatically).
Ejemplo
// Define the characteristics of the Orders.OrdID key
Orders.OrdID.KeyType = hUniqueKey
...
// Validate the data file description
HDescribeFile(Orders)
Sintaxis

Determining if an item is key Ocultar los detalles

<Characteristic> = <Data file>.<item>.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.
hNotAKeyThe item is not a key.
hPrimaryKeyPrimary key. The value assigned to this item will not be null and will be unique in the data file.
hSpatialKeySpatial key. This key heading contains spatial data (geographic and/or geometric data)..
hUniqueKeyUnique key. The value assigned to this item will be unique in the data file. No record in the file will have the same value for this item.
Note: a unique key can authorize a NULL value.
<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.
WINDEVWEBDEV - Código ServidorReportes y ConsultasiPhone/iPadIOS WidgetCódigo de Usuario (UMC)Ajax

Defining a key programmatically Ocultar los detalles

<Item>.KeyType = <Key type>
<Item>: Character string
Name of the item used. This name is defined with the Item Description type.
<Key type>: Integer constant
The characteristics of a key can be:
hDuplicatesKeyKey with duplicates. This item can have the same value for several data file records.
hNotAKeyThe item is not a key.
hPrimaryKeyPrimary key. The value assigned to this item will not be null and will be unique in the data file.
hSpatialKeySpatial key. This key heading contains spatial data (geographic and/or geometric data)..
hUniqueKeyUnique key. The value assigned to this item will be unique in the data file. No record in the file will have the same value for this item.
Note: a unique key can authorize a NULL value.
Versión mínima requerida
  • Versión 9
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 06/12/2024

Señalar un error o enviar una sugerencia | Ayuda local