PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WinDevWebDev - Server codeReports and QueriesWindowsUser code (UMC)HFSQLHFSQL Client/Server
WDLog: Viewing a log file

Overview
WDLog enables you to view the content of a log file:
  • in HyperFileSQL classic mode. The file viewed in WDLog is <NameLoggedFile>JNL.FIC.
  • in HyperFileSQL Client/Server mode. However, we recommend that you use the HyperFileSQL Control Center.
Reminder:
  • The operating mode of the log operations differs between HyperFileSQL Classic and HyperFileSQL Client/Server.
  • In programming, HHistoryModification returns the modifications made to one or more items of a given record.

Interactive mode
Reports and QueriesWindowsHFSQL

To view the JournalOpération.FIC file (HyperFileSQL Classic):

1. Start WDLog.

2. Select "File .. Manage the logs" (or click the book).

3. Click the "Open a HyperFileSQL Classic log" button.

4. Select the log file of your application (XXXJNL.FIC file).

5. The content of the file is displayed.

Reports and QueriesWindowsHFSQL Client/Server

To view the Log file (HyperFileSQL Client/Server):

1. Start WDLog.

2. Select "File .. Manage the logs" (or click the book).

3. Click the "Open a HyperFileSQL Client/Server log" button.

4. Describe the connection to the HyperFileSQL server in the wizard that opens.

5. Select the logged file.

6. The content of the file is displayed.

The information displayed

DateDate when the operation was performed.
TimeTime when the operation was performed.
OperationOperation performed on the data file. In the data file, this operation is identified by a number. The "Number - HyperFileSQL function" correspondence is available in the ListeDefinitionHF.WL file found in the \Personal\External sub-directory of WinDev.
ValuesThe magnifier is used to view the different values of the record:
  • During an addition, the added value is viewed.
  • During a modification, the values before and after the modification are viewed.
  • During a deletion, the deleted values are viewed.
KeyValue of the first unique key of the file.
Network nameName of the computer (up to 12 characters). If this name contains more than 12 characters, the beginning of the name is truncated (indeed, the end of the computer name is the most determinant section).

HFSQL Client/Server The JNLUSER.Fic file enables you to find out the name of the user computer.
ApplicationName of the application that has performed the operation (useful when the files are shared between several applications).
This information is a string on 12 characters.
IP addressIP address of the computer that performed the operation.
HPostIdentifier of the computer that performed the modification (identifier defined by HPost).
This information is a string on 16 characters.
NotesCustom notes defined by HLogInfo.
This information is a string on 12 characters.

Reports and QueriesWindows

Possible operations

This window is used to perform advanced searches on all the elements saved in the log. You can for example search for all the modifications performed by a computer over a specific period or search for all the operations performed by a specific computer.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment