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 / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Deletion and modification rule
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 data file bindings (Merise type) present:
  • in the current analysis,
  • in ongoing analyses (case of projects with multiple analyses).
  • in a specific analysis.
Ejemplo
// Retrieve the links of the Customer data file in the current analysis
ListLink is string
ListLink = Customer.ListLink(hLstDetail)
// Adds the link list to the COMBO_MaCombo field
COMBO_MyCombo.Add(LinkList)
Sintaxis

Listing the links of a data file in an analysis Ocultar los detalles

<Result> = <Source>.ListLink([<Path of the WDD file> [, <Password of the WDD file>]] [, <Options>])
<Result>: Character string
List of links.
Case of projects with multiple analyses: If several analyses are in progress, all links for all analyses in progress are listed (without duplicates).
The different link descriptions are separated by CR characters (Carriage Return). The result is more or less detailed depending on the constant used:
hLstDetail is not specified<Connection Name 1> + TAB + <Data File Name 1.1> + TAB + <Field Name 1.1> + TAB + <Cardinality 1.1> + TAB + <Data File Name 1.2> + TAB + <Field Name 1.2> + TAB + <Cardinality 1.2> + CR + ...
hLstDetail is specified<Link Name 1> + TAB + <Data File Name 1.1> + TAB + <Field Name 1.1> + TAB + <Cardinality 1.1> + TAB + <Data File Name 1.2> + TAB + <Field Name 1.2> + TAB + <Cardinality 1.2> + TAB + <Modification Rule> + TAB + <Deletion Rule> + CR + ...

Where:
  • <Nom Liaison X> Link name.
  • <Nom Fichier de données x.1> Name of data file on primary key side.
  • <Nom Rubrique x.1> Name of the item on the primary key side.
  • <Cardinalité x.1> Cardinality of the link on the primary key side, of the form "<Cardinalité min>,<Cardinalité max>" (for example "0,N" or "1,N").
  • <Nom Fichier de données x.2> Name of data file on foreign key side.
  • <Nom Rubrique x.2> Name of field on foreign key side.
  • <Cardinalité x.2> Cardinality of the foreign key link, of the form "<Cardinalité min>,<Cardinalité max>" (for example "0,N" or "1,N").
  • <Règle de modification> Rule to be applied when modifying the primary key.
  • <Règle de suppression> Rule to be applied if the primary key is deleted.
HFSQL Client/Server The name of data files corresponds to the name of the database + '\' + the relative physical name of these data files.
OLE DBConectores Nativos If one of the links listed is performed on a compound key, the <Nom Rubrique 1.2> parameter returned will correspond to the names of the various components of the key. The names will be separated by a comma.
<Source>: Type corresponding to the specified source
Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed.
<Path of the WDD file>: Optional character string
Full path of the analysis file (.WDD file).
If this parameter is not specified or is equal to an empty string (""), the links are searched for:
  • in the current analysis.
  • in all current analyses (case of projects with multiple analyses).
<Password of the WDD file>: Optional string or Secret string
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>: Optional integer constant
Type of list to perform:
hLstDetailLists the detailed information about the links.
hLstNormal
(default value)
Lists the links.
Hyper File 5.5 This parameter is ignored.

Listing the links of a data file accessible via Native Connector or OLE DB, or via an HFSQL Client/Server connection Ocultar los detalles

<Result> = <Source>.ListLink([<Connection>] [, <Options>])
<Result>: Character string
List of links. The different link descriptions are separated by CR characters (Carriage Return). The result is more or less detailed depending on the constant used:
hLstDetail is not specified<Connection Name 1> + TAB + <Data File Name 1.1> + TAB + <Field Name 1.1> + TAB + <Cardinality 1.1> + TAB + <Data File Name 1.2> + TAB + <Field Name 1.2> + TAB + <Cardinality 1.2> + CR + ...
hLstDetail is specified<Link Name 1> + TAB + <Data File Name 1.1> + TAB + <Field Name 1.1> + TAB + <Cardinality 1.1> + TAB + <Data File Name 1.2> + TAB + <Field Name 1.2> + TAB + <Cardinality 1.2> + TAB + <Update Rule> + TAB + <Delete Rule> + CR + ...

Where:
  • <Nom Liaison X> link name.
  • <Nom Fichier de données x.1> Name of data file on primary key side.
  • <Nom Rubrique x.1> Primary key side field name or specified data file name.
  • <Cardinalité x.1> Cardinality of the link on the primary key side, of the form "<Cardinalité min>,<Cardinalité max>" (for example "0,N" or "1,N").
  • <Nom Fichier de données x.2> Name of data file on foreign key side.
  • <Nom Rubrique x.2> Name of field on foreign key side.
  • <Cardinalité x.2> Cardinality of the foreign key link, of the form "<Cardinalité min>,<Cardinalité max>" (for example "0,N" or "1,N").
  • <Règle de modification> Rule to be applied if the primary key is modified (see Remarks).
  • <Règle de suppression> Rule to be applied if the primary key is deleted (see Remarks).
HFSQL Client/Server The name of data files corresponds to the name of the database + '\' + the relative physical name of these data files.
OLE DBConectores Nativos If one of the listed links is performed in a composite key, the <Name item 1.2> parameter returned will correspond to the name of the different key components. The names will be separated by a comma.
<Source>: Type corresponding to the specified source
Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed.
<Connection>: Character string or Connection variable
Connection to use. This connection corresponds to:
<Options>: Optional integer constant
Type of list to perform:
hLstDetailLists the detailed information about the links.
hLstNormal
(default value)
Lists the links.
Hyper File 5.5 This parameter is ignored.
Observaciones

Deletion and modification rule

The modification and deletion rules returned by <Source>.ListLink can correspond to the following constants:
hIntegrityCascadeManage the cascading modification and deletion.
hIntegrityDefaultValueDuring the deletion, a default value is assigned to the linked records.
hIntegrityForbiddenStrict respect of integrity.
hIntegrityNoneNo integrity constraint.
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: 16/05/2025

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