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 / Gestión de registros
  • Overview
  • JournalOperation.FIC file
  • JournalIdentification.fic file
  • GUID and log process
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
Structure of log files (HFSQL Classic)
HFSQL ClassicDisponible solo con este tipo de conexión
Overview
The following files are automatically created when logging an HFSQL Classic data file:
JournalOperation.FicList of all the operations performed on the logged HFSQL data files used by the application. An operation corresponds to an HFSQL function.
JournalIdentification.FicList of the physical locations of all the logged files found in the application
xxxJNL.FicFile created for each logged file. Contains the value of records used before and after each operation.
This page presents the structure of these files.
JournalOperation.FIC file
The various headings in the JournalOperation.Fic file are as follows:
Id_OpérationIdentifier of the operation performed.
Numéro_EnregistrementNumber of the record used in the data file.
Id_Sauvegarde_Enregistrement_OriginalNumber of the log record corresponding to the record before modification. This record number corresponds to a record in xxxxJNL.Fic.
Id_Sauvegarde_Enregistrement_ModifiéNumber of the log record corresponding to the record after modification. This record number corresponds to a record in xxxxJNL.Fic.
ID_FonctionWLIdentifier of WLanguage function used in the program. To find the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file located in the "Personal\External\" subdirectory of WINDEV or WEBDEV)
Poste_NomName of the computer that performed the operation (last 12 characters).
Poste_AdresseIPIP address of computer that performed the operation.
ApplicationName of the application from which the operation was performed (first 12 characters)
HComputerIDIdentifier of the user computer, defined through programming with HComputer.
HJournalInfoMsgComments about the logged operation. These comments can be configured by HLogInfo.
Heure_Poste_ClientGMT time when the operation was performed on the user computer (2 hours difference with the French summer time).
ID_ReplicaIdentifier of the replica. This item is used by the replication.
ID_FichierJNLIdentifier of the JNL file containing the record backup
JournalIdentification.fic file
The different items found in JournalIdentification.Fic are as follows:
ID_FichierJNLIdentifier of the file used.
GUID_Fichier_SourceUnique identifier of logged file. This identifier is automatically assigned by the HFSQL engine to the file when creating the data file.
GUID_Fichier_JNLUnique identifier of the Log file associated with the Source file. This identifier is automatically assigned by the HFSQL engine to the file when creating the data file.
Emplacement_Fichier_SourcePath of the data file used (logged HFSQL data file).

GUID and log process

Two types of file GUID are supported by the HFSQL engine:
  • File GUID defined when the file was described in the data model editor. This GUID is used to manage the .REP.
  • File GUID defined when creating the physical data file. This GUID is used by the log mechanism to detect that two data files do not use the same log file.
  • file
WINDEVWindowsHFSQL Classic The *JNL.Fic file contains:
  • all the items of the corresponding logged HFSQL file,
  • the following items:
Id_SauvegardeNumber of the record saved. This number is used to identify Record in the JournalOperation.Fic file.
Numéro_EnregistrementNumber of the record in the initial logged file.
Etat_EnregistrementReport from Record (modified, deleted, added, etc.).
ID_FonctionWLIdentifier of WLanguage function used in the program. To find the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of WINDEV)
Poste_NomName of the computer that performed the operation (last 12 characters).
Poste_AdresseIPIP address of computer that performed the operation.
ApplicationName of application from which the operation was performed (first 12 characters).
HComputerIDIdentifier of the user computer, defined through programming with HComputer.
HJournalInfoMsgComments about the logged operation. These comments can be configured by HLogInfo.
Heure_Poste_ClientGMT time when the operation was performed on the user computer (2 hours difference with the French summer time).
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: 11/04/2024

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