PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Interactive mode
  • Viewing the JournalOpération.FIC file (HFSQL Classic)
  • Viewing the Log file (HFSQL Client/Server)
  • The information displayed
  • Possible operations
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Interactive mode
WINDEVWEBDEV - Server codeReports and QueriesWindowsUser code (UMC)HFSQL

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

To view the JournalOpération.FIC file (HFSQL Classic)
  1. Start WDLog.
  2. Select "File .. Manage the logs" (or click the book).
  3. Click the "Open a HyperFileSQL Classic log" button.Click the "Open a HFSQL Classic log" button.
  4. Select the log file of your application (XXXJNL.FIC file).
  5. The content of the file is displayed.
WINDEVWEBDEV - Server codeReports and QueriesWindowsUser code (UMC)HFSQL Client/Server

Viewing the Log file (HFSQL Client/Server)

To view the Log file (HFSQL 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.Click the "Open a HFSQL Client/Server log" button.
  4. Describe the connection to the HFSQL server in the wizard.
  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 correspondence "Number - HFSQL function" is available in the ListeDéfinitionHF.WL file found in the \Personal\Extern 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 allows you to find out the name of the user computer.
ApplicationName 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 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.
WINDEVWEBDEV - Server codeReports and QueriesWindowsUser code (UMC)

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 required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment