ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Format of the lines in the text file
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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.
Remark: This function is an advanced function.
Example
// Retrieve the server logs for 2018
IF HRetrieveLog("MyConnection", "20180101", "20183112", "C:\My Documents\MyLogs.txt") = False THEN
Error("The logs have not been retrieved: " + HError())
END
Syntax
<Result> = HRetrieveLog(<Connection> , <Start date> , <End date> , <Destination Log file> [, <Progress Bar>])
<Result>: Boolean
  • True if the logs have been retrieved,
  • 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: Beginning 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) +
    • <Identifier of parameter 2> + "=" + <Value of parameter 2> + Charact(0) + Charact(255) + ... +
    • <Identifier of parameter N> + "=" + <Value of parameter N> + Charact(0)
Component: wd290hf.dll
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help