AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Displaying the result in a List Box or Combo Box control
  • Extracting information from the result
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
Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. You can determine:
  • the type of key,
  • its size,
  • whether the key is unique or with duplicates, etc.
The files defined by <Source>.Declare, <Source>.DeclareExternal and <Source>.DescribeFile are taken into account.
Ejemplo
// Récupérer les clés d'un fichier de données présent dans l'analyse en cours
ListeCle is string
ListeCle = Client.ListeClé(hLstDetail)
// Ajoute la liste des clés dans COMBO_COMBO1
COMBO_COMBO1.Ajoute(ListeCle)
Sintaxis
<Result> = <Source>.ListKey([<Path of the WDD file> [, <Password of the WDD file> [, <Options>]]])
<Result>: Cadena de caracteres
List of items found in the specified data file. The different descriptions of each key are separated by CR characters (Carriage Return). The listed keys are sorted according to the physical order of the keys in the data file (except if the hLstSorted constant is used).
The result is more or less detailed depending on the constant used:
hLstDetail is not specified<Name of key 1> + CR + <Name of key 2 + CR + ...
The result with the constants hLstKey and/or hLstCompoundKey and/or hLstSorted is identical.
hLstDetail is specified<Name of key 1> + TAB + <Type> + TAB+ <Size> + TAB + <Expression> + TAB + <Unique> + TAB + <Caption> + CR +...
hLstDetailPlus<Name of key 1> + TAB + <Type> + TAB + <Size> + TAB + <Expression> + TAB + <Unique> + TAB + <Caption> + TAB + <Integer part of numeric keys> + TAB + <Decimal part of numeric keys> + CR +...
Where:
  • <Nom de clé X> key name.
  • <Type> key type: "T" for text (and monetary) or "N" for numeric.
  • <Taille>: column size.
  • <Formule>: key formula if the key is compound (if the key is simple, only the key name is returned).
  • <Unique>:
    • "2" for primary keys.
    • "1" for a unique key,
    • "0" for a key with duplicates.
  • <Libellé>: key label.
  • <Partie entière des clés numériques> number of digits in the integer part of numeric keys.
  • <Partie décimale des clés numériques> number of digits in the decimal part of numeric keys.
<Source>: Tipo de fuente especificada
Name of data file (query or view) whose keys will be listed.
If a query name is specified, the query must be running ( or ) to use . Otherwise, a WLanguage error occurs.
<Path of the WDD file>: Cadena de caracteres opcional
Full path of the analysis (i.e. the .WDD file) in which the data file has been defined.
If this parameter is not specified or is an empty string (""), the data file is searched for in the current analysis.
<Password of the WDD file>: Cadena de caracteres opcional
Password defined for the analysis.
If no password is defined, this parameter must be an empty string ("").
Novedad versión 2025
Cadenas secretas: Si utiliza el almacén de cadenas secretas, el tipo de cadena secreta utilizado para este parámetro debe ser "ANSI o Unicode string".
Para obtener más información sobre las cadenas secretas y el almacén, consulte Almacén de cadenas secretas.
<Options>: Constante o combinación de constantes de tipo Integer (opcional)
Type of list to perform:
hLstAllLists all the keys (hLstKey + hLstCompositeKey).
Hyper File 5.5 This constant is ignored.
hLstCompositeKeyLists the composite key items only.
Hyper File 5.5 This constant is ignored.
hLstDetailDetailed information (idem WINDEV 5.5).
hLstDetailPlusFor the numeric keys, add the number of digits found in the integer part and in the decimal part.
Hyper File 5.5 This constant is ignored.
hLstKeyLists the key items (non-composite keys only).
Hyper File 5.5 This constant is ignored.
hLstLogicalOrderSorts the list in logical order of items (ignored if hLstSorted is specified).
Hyper File 5.5 This constant is ignored.
hLstNormal
(default value)
Corresponds to hLstAll. Default value used if constants hLstKey, hLstCompoundKey and hLstAll are not used.
hLstOriginalItemUsed on a log file (xxxJNL.fic), lists the keys of the initial source file (that was logged). For example, on CustomerJNL.Fic, list the key items of CUSTOMER file.
Hyper File 5.5 This constant is ignored.
hLstSortedSorts the list in ascending order.
Hyper File 5.5 This constant is ignored.
Observaciones

Displaying the result in a List Box or Combo Box control

<Result> can be directly assigned to a List Box or Combo Box control by <List Box>.add. Each row will contain the name of one of the keys found.

Extracting information from the result

To extract information from the detailed result, it is recommended to use <Cadena ANSI>.ExtractString.
Componente: wd300hf.dll
Versión mínima requerida
  • Versión 25
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 26/09/2024

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