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 functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Checks the structural integrity of memos in an HFSQL data file.
New in SaaS
HFSQL Client/Server The structural integrity of memos in an HFSQL Client/Server data file can be checked asynchronously using the HCheckMemoAsynchronous function.
Note: This feature is only available from WINDEV Suite SaaS 2025 - Update 2.
For more details, see Using new features exclusive to WINDEV Suite SaaS 2025.
Example
IF HCheckMemo(Client, JAUGE_Jauge1) <> "" THEN
	Info("Mémo corrompu")
END
Syntax
<Result> = HCheckMemo(<Data file name>)
<Result>: Character string
  • Empty string ("") if there is no problem.
  • In case of problem, string in the following format:
    <Item 1> + TAB + <Record number 1> + CR + ...
    <Item N> + TAB + <Record number N>
    where:
    • <Item X> is the memo item,
    • <Record number> is the number of the record containing the Memo item.
  • HFSQL Client/Server In the event of corruption of the list of free blocks, <Résultat> will be of the form:
    <TAB> + "-1"+ CR + <Item 1> + TAB + <Record number 1> + CR + ...
    <Item N> + TAB + <Record number N>
<Data file name>: Character string
Name of the HFSQL data file to check.
Remarks
  • The list of free blocks is checked in HFSQL Client/Server only.
  • HCheckMemo is faster than HIndex with the hCheckMemo constant..
  • If a problem is detected, you can use HIndex with the hCheckMemo constant.
  • From version 27 onwards, memo verification has been enhanced and deepened, which may result in longer processing times.
Component: wd300hf.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/28/2025

Send a report | Local help