WDLog: Viewing a log file

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Tools

WDLog

WDLog: Viewing a log file

Overview

Interactive mode

See also

WDLog: Viewing a log file

Available only with these kinds of connection

Overview

WDLog allows you to view the content of a log file:

in HFSQL Classic mode. The file viewed in WDLog is <NameLoggedFile>JNL.FIC.
in HFSQL Client/Server mode. However, we recommend that you use the HFSQL Control Center.

Reminder:

The operating mode of the log process presents differences between HFSQL Classic and HFSQL Client/Server.
In programming, HHistoryModification returns the modifications made to one or more items of a given record.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Interactive mode

Viewing the JournalOpération.FIC file (HFSQL Classic)

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

Start WDLog.
Select "File .. Manage the logs" (or click the book).
Click the "Open a HFSQL Classic log" button.
Select the log file of your application (XXXJNL.FIC file).
The content of the file is displayed.

Viewing the Log file (HFSQL Client/Server)

To view the Log file (HFSQL Client/Server)

Start WDLog.
Select "File .. Manage the logs" (or click the book).
Click the "Open a HFSQL Client/Server log" button.
Describe the connection to the HFSQL server in the wizard.
Select the logged file.
The content of the file is displayed.

The information displayed


Date	Date when the operation was performed.
Time	Time when the operation was performed.
Operation	Operation performed on the data file. In the data file, this operation is identified by a number. The correspondence "Number - HFSQL function" is available in the ListeDéfinitionHF.WL file found in the \Personal\Extern sub-directory of WINDEV.
Values	The 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.
Key	Value of the first unique key of the file.
Network name	Name 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). The JNLUSER.Fic file allows you to find out the name of the user computer.
Application	Name of the application that has performed the operation (useful when files are shared between several applications). This information is a string on 12 characters.
IP address	IP address of computer that performed the operation.
HPost	Identifier of the computer that performed the modification (identifier defined by *HPost*). This information is a string on 16 characters.
Notes	Custom notes defined by *HLogInfo*. This information is a string on 12 characters.

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.