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
WindowsLinuxUniversal Windows 10 AppJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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 through programming
  • Define a key item (when the item is described through programming).
Ejemplo
// Définir les caractéristiques la rubrique clé Commande.IdCde
Commande.IDCde.TypeClé = hUniqueKey
...
// Valide la description du fichier de données
HDescribeFile(Commande)
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 only be in the data file.
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.
Remark: 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.
Reportes y Consultas

Defining a key through programming 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 only be in the data file.
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.
Remark: 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: 29/02/2024

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