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
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
Returns the list of a data file links (Merise type) present.:
  • in the current analysis,
  • Novedad versión 2024
    in ongoing analyses (case of projects with multiple analyses).
  • in a specific analysis.
Ejemplo
// Récupérer les liaisons du fichier de données Client de l'analyse en cours
ListeLiaison is string
ListeLiaison = Client.ListeLiaison(hLstDetail)
// Ajoute la liste des liaisons dans le champ COMBO_MaCombo
COMBO_MaCombo.Ajoute(ListeLiaison)
Sintaxis

Listado de enlaces de un archivo de datos en un análisis Ocultar los detalles

<Result> = <Source>.ListLink([<Path of the WDD file> [, <Password of the WDD file>]] [, <Options>])
<Result>: Cadena de caracteres
List of links.
Novedad versión 2024
Projects with multiple analyses: If several analyses are in progress, all links of 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<Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + CR +...
hLstDetail is specified<Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + TAB + <Modification rule> + TAB + <Deletion rule> + CR +...

Where:
  • <Name link X>: link name.
  • <Name file x.1>:: Name of the data file related to the primary key.
  • <Name item x.1>: Name of the item related to the primary key or name of the specified data file.
  • <Cardinality x.1>: Cardinality of the link related to the primary key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
  • <Name file x.2>: Name of the data file related to the foreign key.
  • <Name item x.2>: Name of the item related to the foreign key.
  • <Cardinality x.2>: Cardinality of the link related to the foreign key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
  • <Modification rule>: Rule to apply if the primary key is modified.
  • <Deletion rule>: Rule to apply 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 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>: Tipo de fuente especificada
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>: Cadena de caracteres opcional
Full path of the analysis file (.WDD file).
If this parameter is not specified or is equal to an empty string (""), links are searched for:
  • in the current analysis.
  • Novedad versión 2024
    in all current analyses (case of projects with multiple analyses).
<Password of the WDD file>: Cadena de caracteres opcional
Password defined for the analysis. If no password is defined, this parameter must be equal to an empty string ("").
<Options>: Constante opcional de tipo Integer
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.

Listado de los enlaces de un archivo de datos accesibles a través de Conector Nativo u OLE DB, o a través de una conexión HFSQL Client/Server Ocultar los detalles

<Result> = <Source>.ListLink([<Connection>] [, <Options>])
<Result>: Cadena de caracteres
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<Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + CR +...
hLstDetail is specified<Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + TAB + <Modification rule> + TAB + <Deletion rule> + CR +...

Where:
  • <Name link X>: link name.
  • <Name file x.1>:: Name of the data file related to the primary key.
  • <Name item x.1>: Name of the item related to the primary key or name of the specified data file.
  • <Cardinality x.1>: Cardinality of the link related to the primary key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
  • <Name file x.2>: Name of the data file related to the foreign key.
  • <Name item x.2>: Name of the item related to the foreign key.
  • <Cardinality x.2>: Cardinality of the link related to the foreign key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
  • <Modification rule>: Rule to apply if the primary key is modified (see Remarks).
  • <Deletion rule>: Rule to apply 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>: Tipo de fuente especificada
Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed.
<Connection>: Cadena de caracteres o variable de tipo Connection
Connection to use. This connection corresponds to:
<Options>: Constante opcional de tipo Integer
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 <Fuente>.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: wd290hf.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: 13/04/2024

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