Home | Sign in | English UK

  • WLanguage procedure
  • Special cases
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
HTrack (Function)
In French: HSurveille
HFSQL Client/ServerAvailable only with this kind of connection
Starts tracking the write actions (addition, modification or deletion) performed on a file found on a HFSQL server. In case of modification, a specific procedure can be triggered.
This track can be stopped by HTrackStop.
// Starts tracking the Order file
// The ProcessOrder procedure is called whenever a record is added into the file
HTrack(Order, ProcessOrder, hRecNumAll, hsAdd)
<Result> = HTrack(<File Name> , <Procedure Name> [, <Record Number> [, <Action to Track>]])
<Result>: Boolean
  • True if the tracking is enabled,
  • False otherwise. To find out the error details, use ErrorInfo.
<File Name>: Optional character string (with or without quotes)
Name of HFSQL data file to use. The data file is associated with a connection and with a server.
If this parameter corresponds to an empty string (""), HTrack handles the last data file used by the last function for HFSQL management (starting with the letter H).
<Procedure Name>: Character string (with or without quotes)
Name of WLanguage procedure ("callback" procedure) that will be called when a change is detected in the specified data file. This procedure has the following format:
PROCEDURE <Procedure Name>(<Name of Modified File>,
<Modified Record Number>, <Action>)

  • <Name of Modified File> is a data source corresponding to the modified HFSQL file,
  • <Modified Record Number> corresponds to the number of the modified record (equivalent to the number returned by HRecNum),
  • <Action> corresponds to the action that triggered the procedure. The possible values are:
    hsAddProcedure started once a record is added into the data file.
    hsModificationProcedure started once a record is modified in the data file.
    hsCrossProcedure started once a record is crossed in the data file.
    hsDeletionProcedure started once a record is deleted from the data file.
<Record Number>: Optional integer
  • Number of the record to track.
  • hRecNumAll constant to track all the records found in the data file (which means the entire data file).
<Action to Track>: Optional constant (or combination of constants)
Actions to track for which the procedure will be started:
hsAddMonitors the operations for adding records.
hsModificationMonitors the operations for modifying records.
hsCrossMonitors the operations for crossing records.
hsDeletionMonitors the operations for deleting records.

WLanguage procedure

The WLanguage procedure is called in the main thread of the application, with the HFSQL context corresponding to the procedure:
  • If the procedure is a local procedure of a window that is using an independent context, the context used will be the one of the window.
  • If the procedure belongs to a component that is using an independent context, the context used will be the one of the component.
The procedure associated with HTrack can be called at any time in the application.
If the procedure performs HFSQL browses or moves in the data files, this will impact the application (like the timers).
Therefore, you may have to call HSavePosition and HRestorePosition to save the contexts of files used.
Multitask must not be used in the procedure code.

Special cases

The track is defined for a data file and a connection:
  • If the physical name or the connection associated with the logical file name changes, the file tracked by the server remains the one specified during the call to HTrack.
  • If the connection is closed, the track is automatically stopped.
To stop tracking the data file, use HTrackStop.
WEBDEV - Server code wd220hf.dll
Linux wd220hf.so
Minimum version required
  • Version 22
This page is also available for…
Click [Add] to post a comment