HCheckMemo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HCheckMemo (Function)

In french: HVérifieMémo

Checks the structural integrity of memos in an HFSQL data file.

New in SaaS

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> [, <Progress Bar>])

<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.
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.

<Progress Bar>: Optional window or control name

Name of the window in which the progress bar will be displayed.
Name of the Progress Bar control.
This parameter is ignored.

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