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
  • Data file JNL_FILES.FIC
  • Data file JNL_OPERATION.FIC
  • Data file JNL_USERS.FIC
  • Data file *JNL.FIC (log file)
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
Structure of log files (HFSQL Client/Server)
HFSQL Client/ServerDisponible solo con este tipo de conexión
Overview
The following files are automatically created when logging an HFSQL Client/Server data file:
JNL_FILES.FICDescription of log data files.
JNL_OPERATION.FICDescription of actions performed on a log data file.
JNL_USERS.FICDescription of users performing an action on a log data file.
xxxJNL.FICFile created for each log data file. Contains the value of records used before and after each operation.

These files are created according to the following structure:
1. __JNL directory
This directory contains:
  • The data file log file.
  • The user log.
  • The operation log.
  • For each log data file in each database, the corresponding log file. The tree structure used corresponds to the tree structure of the data files associated with the database.
For exampleif the Command data file in DataApplicationA is logged, the subdirectory __JNL\DataApplicationA will contain the data file CommandJNL.FIC.
Another example If the Customer data file of DataApplicationB is jounalized, the subdirectory __JNL\DataApplicationA\Customer will contain the data file CustomerJNL.FIC.
2. Database directory DataApplicationA
3. Database directory DataApplicationB
This page presents the structure of these files.
Data file JNL_FILES.FIC
The various fields in the JNL_FILES.FIC data file are as follows:
JNLFile_IDData file identifier.
Source_DB_File_LocationName of database + '\' + relative path of log file.
Source_File_GUIDGUID of log data file.
JNL_File_GUIDGUID of write-to-file log.
Data file JNL_OPERATION.FIC
The various fields in the JNL_OPERATION.FIC data file are as follows:
Operation_IDIdentifier of the operation.
USER_IDIdentifier of user who performs the operation. This identifier corresponds to the identifier of the data file JNL_USER.Fic
JNLFile_IDIdentifier of logged file where the operation is performed. This identifier corresponds to the identifier of the data file JNL_FILES.Fic.
WLFunction_IDIdentifier of the WLanguage function used in the program. To find out the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of the product)
Server_TimeDate of operation on the server (in UTC format, universal time)
Record_NumberNumber of the modified record
Source_Record_Backup_IDIdentifier in the file of values. Corresponds to the record value before the operation.
Modified_Record_Backup_IDIdentifier in the file of values. Corresponds to the record value after the operation.
HLogInfoMsgValue defined by HLogInfo.
HComputer_IDText defined by HComputer.
Data file JNL_USERS.FIC
The various fields in the JNL_USERS.FIC data file are as follows:
USER_IDUser identifier.
LoginUsername.
Workstation_NameName of user computer.
Workstation_IPAddressIP address of user computer.
ApplicationApplication name
Data file *JNL.FIC (log file)
The data file *JNL.Fic contains:
  • the items found in the table below,
  • all log fields in the corresponding HFSQL log data file.
USER_IDIdentifier of the user who performed the operation. This number identifies the record in the JNL_Users.Fic data file
Record_NumberRecord number in original log file.
Record_StatusRecord status (modified, deleted, added, ...)
WLFunction_IDIdentifier of the WLanguage function used in the program. To find out the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of the product used)
Server_TimeDate of operation on the server (in UTC format, universal time)
HLogInfoMsgValue defined by HLogInfo.
HComputer_IDText defined by HComputer.
IDJNLIdentifier of the log
Versión mínima requerida
  • Versión 10
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 27/03/2025

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