PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • What is a log?
  • Use
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
The log process
HFSQLHFSQL Client/ServerAvailable only with these kinds of connection
Overview

What is a log?

The log is a special file where are stored all the operations performed on one or more data files from a given time (file creation, last automatic data modification, last backup performed by WDLog, ...).
The log contains the history of the data files use, that is:
  • The full backup before it is used or modified by the user,
  • The full backup once it has been used or modified by the user,
  • The author of the operation or modification,
  • The date of the operation or modification,
  • The nature of the performed operation (addition, modification, deletion, read operation).
Use
The log can be handled by WDLog. The following operations can be performed from a log:
  • Restore the content of a logged data file if the data file is lost or destroyed
  • Restore the content of a logged data file up to a given date
  • Find the author, the date and time of an operation performed on a specific record
  • Keep the history of the file use (to calculate statistics for instance)
Examples:
  • The last backup was done a month ago. You made a mistake when using the file. The log enables you to retrieve your data, without loosing the data from the last month of work!
  • A user entered the orders of last week instead of the orders of this week during the entire morning. To avoid losing a large amount of data, we advise you to restore all the analysis files to their previous status (yesterday evening).
    The operation is straightforward. The person in charge of maintenance will restore the data files that were previously saved by WDLog. Via the log, WDLog can rebuild the files, operation by operation, from the last backup up to the chosen time.
Notes:
  • The log process is available in HFSQL Classic mode and in HFSQL Client/Server mode.
  • The log process is not available when accessing a database via Remote access.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment