PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Interactive mode
  • Saving the HFSQL data files associated with an analysis
  • Command Line mode
  • Saving all the data files found in a WDD file or in a .REP file
  • Saving all the data files found in a HFSQL Client/Server database
  • Saving all the data files found in a list
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 save all the HFSQL data files used by a WINDEV or WEBDEV application.
The following file is required to perform this backup:
  • the analysis file (.WDD),
  • the .REP file that contains the different paths of the data files managed by the project.
This backup can be performed:
  • In interactive mode (WDLog is started).
  • In "Command line" mode. The "Command line" mode allows you to include the management of file backups in your applications. In this case, no specific operation must be performed by the user.
Important: Don't forget to write down the references of all the backups performed (date of backup, directory of backup, nature of backup, diskette containing the files or the logs, ...). This information is fundamental when restoring the files.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Interactive mode

Saving the HFSQL data files associated with an analysis

To save the HFSQL data files associated with an analysis:
  1. Start WDLog.
  2. Select "Backups .. Save the data" (or click the orange arrow).
  3. With the "Browse" button, select:
    • The analysis file (.WDD) that contains the description of data files managed by the project.
    • The .REP file that contains the different paths of the data files managed by the project.
  4. The list of data files found in the application .REP is displayed. In this list, you can:
    • Delete files (.FIC, .MMO or .NDX files) with the "Remove" button.
    • Add HFSQL data files (.FIC, .MMO or .NDX files) with the "Other" button.
    • Save the list of data files in a "List" file (LST extension) with the "Save" button. This list file can be read by WDLog or used in command line.
      Caution: The "list" file is not cleared whenever a backup is performed.
    • Open a list of data files with the "Open" button.
  5. Click the "OK" button to validate the backup of data files.
  6. Specify the following elements in the backup window:
    • Backup directory: Directory in which the backup directory will be created.
    • Backup name: Name of the directory where the backup will be performed.
    • Specify the backup options:
      • Don't create a sub-directory named like the backup: The backup directory is not created.
      • Compression: used to compress the files during backup. This option is used to reduce the storage size of backups. A single archive file (WDZ) will be created.
        If this option is not checked, the files will only be copied into the backup directory.
      • Multi-volumes: used to compress the files during the backup and to group the files in archives (1.4 MB). This option is recommended if the backup must be performed on diskettes. This option automatically enables the "Compression" mode.
      • Don't save the indexes (.NDX): used to reduce the size of the backup. If this option is checked, the files must be reindexed once they have been restored.
        Reminder: Several methods are available to reindex the data files: WDTOOL (cannot be redistributed), WDOptimizer, WDMAP (cannot be redistributed), or by programming with HIndex.
      • Don't lock the files: used to save the files even if they are currently used. This option is not recommended because the backup may contain locked records that can no longer be accessed.
        This option is recommended in some specific cases, for the applications started in background task that open files but that do not use the transactions for example, ... This option can also be used with applications that handle independent data files (not linked in the analysis).
  7. Click the "OK" button to start the backup.
Command Line mode
Two types of backups are available in command line mode:
  • Saving all the data files described either in an analysis, or in the .REP file of the application.
  • Saving a list of data files.
See the previous paragraph ("Interactive mode") for more details.
Note: A WDLOG.LOG file is automatically created. This file contains the operations performed.

Saving all the data files found in a WDD file or in a .REP file

The following syntax allows you to save all the data files found in a WDD file or in a .REP file:
WDLog /APPLI=<FullWDDName or FullREPName>
/REP = <BackupDir>
/COMPRESS = <True/False>
/MUET = <True/False>
/MULTI = <True/False>
/SANSBLOCAGE = <True/False>
/SANSINDEX = <True/False>
/SANSSOUSREP = <True/False>
Details of parameters:
ParameterMeaning
/APPLI = <FullWDDName or FullREPName>Character string containing the full name of the analysis (".WDD" file) or the full name of the ".REP" file of the application.
/REP=<BackupDir>Path where the files will be saved
/COMPRESS=<True/False>The data files will be compressed if this option is set to "True". The files will be saved in an archive (.WDZ file).
Otherwise, the files will not be compressed.
This option is set to "True" by default.
/MUET=<True/False>If this option corresponds to "True", if a locking error occurs, all the operations performed will be written into a result file (.LOG file). The execution of WDLog will not be locked.
Otherwise, a window will be displayed if an error occurs.
This option is set to "False" by default.
/MULTI=<True/False>The backup archive will be divided into files (1.4 MB) if this option is set to "True". There is no need to specify the compression option if this option is used.
Otherwise, the archive will not be divided.
This option is set to "False" by default.
/SANSBLOCAGE=<True/False>Only the data files that are not locked will be saved if this option is set to "True".
Otherwise, all the data files will be saved.
This option is set to "False" by default.
/SANSINDEX=<True/False>The indexes of the data files will not be saved if this option is set to "True".
Otherwise, the indexes will be saved.
This option is set to "False" by default.
/SANSSOUSREP=<True/False>The backup sub-directory will not be created if this option is set to "True". The backup will be performed in the <BackupDir> directory.
Otherwise, a backup sub-directory will be created.
This option is set to "False" by default.
Example: The following command line is used to save all the files found in "C:\MyProject\MyAnalysis.WDD" into "D:\Project Backup". These files will be compressed. The index files will not be saved.
Caution: If the names of directories contain space characters, the parameter must be enclosed in quotes.
ExeRun("WDLog /APPLI= C:\MyProject\MyAnalysis.WDD " + ...
"/REP=""D:\Backup of my projects"" /COMPRESS=True /SANSINDEX=True")

Saving all the data files found in a HFSQL Client/Server database

The following syntax allows you to save all the data files found in a HFSQL Client/Server database:
WDLog /SERVEUR = <Server Name>
/BD = <Database name>
/NOM = <User name>
/MDP_DB = <Password>
/REP = <BackupDir>
/COMPRESS = <True/False>
/MUET = <True/False>
/MULTI = <True/False>
/SANSSOUSREP = <True/False>
/LISTE = <FileName>
/APPLI = <AppName>
Details of parameters:
ParameterMeaning
/SERVEUR=<Server name>Character string containing the name or IP address of the HFSQL Client/Server server.
/BD = <Database name>Character string containing the name of the HFSQL Client/Server database to save.
/NOM = <User name>Character string containing the name of the user who connects to the database.
/MDP_DB = <Password>Character string containing the password associated with the user for the database.
/REP=<BackupDir>Path where the files will be saved
/COMPRESS=<True/False>The data files will be compressed if this option is set to "True". The files will be saved in an archive (.WDZ file).
Otherwise, the files will not be compressed.
This option is set to "True" by default.
/MUET=<True/False>If this option corresponds to "True", if a locking error occurs, all the operations performed will be written into a result file (.LOG file). The execution of WDLog will not be locked.
Otherwise, a window will be displayed if an error occurs.
This option is set to "False" by default.
/MULTI=<True/False>The backup archive will be divided into files (1.4 MB) if this option is set to "True". There is no need to specify the compression option if this option is used.
Otherwise, the archive will not be divided.
This option is set to "False" by default.
/SANSSOUSREP=<True/False>The backup sub-directory will not be created if this option is set to "True". The backup will be performed in the <BackupDir> directory.
Otherwise, a backup sub-directory will be created.
This option is set to "False" by default.
/LISTE = <FileName>Full name of the file containing the list of data files to save. This text file contains one file name per line. It can be created by WDLog ("Save" button).
Example:
E:\WD Stock Chart\Exe\Action.FIC
E:\WD Stock Chart\Exe\Share2000.FIC
E:\WD Stock Chart\Exe\Rate.FIC
/APPLI=<AppName>Name of the application that will be used to identify the backup ("Automatic backup of " + <AppName>).
Example: The following command line is used to save all the files found in "MyHFDatabase" into "D:\Project Backup". These files will be compressed. The index files will not be saved.
ExeRun("WDLog /SERVEUR= 123.123.123.1 "+...
"/BD=MyHFDatabase /NOM=Flo /MDP_DB=Test"+...
"/REP=""D:\Backup of my projects"" /COMPRESS=True"+ ...
"/SANSINDEX=True" /APPLI="MyHFDatabase")

Saving all the data files found in a list

To save a list of data files, create a text file containing the different physical names of the files to save. This file can be created by WDLog run in interactive mode.
The command line is as follows:
WDLog /LISTE = <FileName>
         /REP = <BackupDir>
         /COMPRESS = True
         /MUET = True
         /MULTI = True
         /SANSBLOCAGE = True
         /SANSINDEX = True
         /SANSSOUSREP = True
The table below presents the different elements that can be found on the command line:
ParameterMeaning
/LISTE = <FileName>Name of the file containing the list of data files to save. This text file contains one file name per line. It can be created by WDLog ("Save" button).
Example:
E:\WD Stock Chart\Exe\Action.FIC

Name of the file containing the list of data files to save. This text file contains one file name per line. It can be created by WDLog ("Save" button).
Example:
E:\WD Stock Chart\Exe\Action.FIC
E:\WD Stock Chart\Exe\Share2000.FIC
E:\WD Stock Chart\Exe\Rate.FIC
/REP=<BackupDir>Path where the files will be saved
/COMPRESS=TrueThe data files will be compressed if this option is set to "True". The files will be saved in an archive (.WDZ file)
/MUET=TrueIf this option corresponds to "True", if a locking error occurs, all the operations performed will be written into a result file (.LOG file). The execution of WDLog will not be locked.
/MULTI=TrueThe backup archive will be divided into files (1.4 MB) if this option is set to "True". There is no need to specify the compression option if this option is used.
/SANSBLOCAGE=TrueOnly the data files that are not locked will be saved if this option is set to "True".
/SANSINDEX=TrueThe indexes of the data files will not be saved if this option is set to "True".
/SANSSOUSREP=TrueThe backup sub-directory will not be created if this option is set to "True". The backup will be performed in the <BackupDir> directory.
Example: The following command line is used to save the files found in "C:\MyList.LST" into "D:\Backup". The files currently used will not be saved.
ExeRun("WDLog /LISTE=C:\MyList.LST /REP=D:\Backup/SANSBLOCAGE=True")
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment