WDLog: Viewing a log file

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

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.

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 "Open an HFSQL Classic log".
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 "Open an HFSQL Client/Server log".
Describe the connection to the HFSQL server in the wizard.
Select the logged file.
The content of the file is displayed.

The information displayed


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.
Date	Date when the operation was performed.
HComputer	Identifier of the computer that performed the modification (identifier defined by *HComputer*). This information is a string on 16 characters.
IP address	IP address of computer that performed the operation.
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.
Notes	Custom notes defined by *HLogInfo*. This information is a string on 12 characters.
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 located in the \Personal\Extern subdirectory of WINDEV.
Time	Time when the operation was performed.
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.

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.