ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Format of the lines in the text file
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HRetrieveLog (Function)
In french: HRécupèreLog
HFSQL Client/ServerAvailable only with this kind of connection
Creates a text file containing the server logs between two given dates.
Note: This is an advanced function.
Example
// Récupération des logs du serveur pour 2018
IF HRetrieveLog("MaConnexion", "20180101", "20183112", "C:\Mes Documents\MesLogs.txt") = False THEN
	Error("Les logs n'ont pas pu être récupérés : " + HError())
END
Syntax
<Result> = HRetrieveLog(<Connection> , <Start date> , <End date> , <Destination Log file> [, <Progress Bar>])
<Result>: Boolean
  • True if logs have been recovered,
  • False otherwise. HError is used to identify the error.
<Connection>: Character string or Connection variable
Connection to the server from which the logs must be retrieved. This connection corresponds to:
<Start date>: Character strings
Date from which the server logs must be retrieved. This date is in "YYYYMMDDHHmmSSCCC" format. If only the date is specified ("YYYYMMDD"), it will be rounded up automatically. For example, "20061121" will be rounded to "20061121000000000".
<End date>: Character string
Date until which the server logs must be retrieved. This date is in "YYYYMMDDHHmmSSCCC" format. If only the date is specified ("YYYYMMDD"), it will be rounded up automatically. For example, "20061121" will be rounded to "20061121235959999".
<Destination Log file>: Character string
Text file into which will be written the content of the server log between the two dates. If this file already exists, it will be overwritten.
<Progress Bar>: Optional control name, optional window name or optional integer
Progress Bar:
  • Name of the window where the progress bar will be displayed or name of the Progress Bar control.
  • Handle of the window that displays the progress bar.
WEBDEV - Server code This parameter is ignored.
Remarks

Format of the lines in the text file

The lines in the text file have the following format:
  • For a call:
    <Line Size> + TAB + <Type> + TAB + <Call Identifier> + TAB + <Date> + TAB +
    <Thread Identifier> + TAB + <Context Identifier> + TAB + <Login> + TAB +
    <Client Computer> + TAB + <Client Application> + TAB + <Application Version> + TAB +
    <Function Number> + TAB + <Parameters>
  • For the end of a call:
    <Line Size> + TAB + <Type> + TAB + <Call Identifier> + TAB +
    <Date>  + TAB +  <Context Identifier> + TAB + <Parameters>
Where:
  • <Line size> is a 8-character hexadecimal number used to define the size of the line for the logs, the 8 characters not being taken into account in the specified size.
  • <Type> can take the following values:
    • 1: Start of function
    • 2: End of function
    • 3: ERror
  • <Date> has the following format: YYYYMMDDHHmmSSCCC
  • <Parameters> has the following format:
    • <Identifier of parameter 1> + "=" + <Value of parameter 1> + Charact(0) + Charact(255) +
    • <Identifiant du paramètre 2> + "=" + <Valeur du paramètre 2> + Caract(0) + Caract(255) + ... +
    • <Identifier of parameter N> + "=" + <Value of parameter N> + Charact(0)
Component: wd300hf.dll
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/12/2025

Send a report | Local help