HCheckMemo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

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

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.

Example

IF HCheckMemo(Customer, PROGBAR_ProgBar1) <> "" THEN
Info("Memo corrupted")
END

Syntax

<Result> = HCheckMemo(<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.
If the list of free blocks is corrupted, <Result> will contain:

<TAB> + "-1"

<Result> will have the following format:

<TAB> + "-1"+ CR + <Item 1> + TAB + <Record number 1> + CR + ...
<Item N> + TAB + <Record number N>

<File name>: Character string (with or without quotes)

Name of HFSQL data file to check.

<Progress Bar>: Optional window or control name

Name of window where the progress bar will be displayed.
Name of Progress Bar control that displays the progress.
This parameter is ignored.

Remarks

The list of free blocks is checked in HFSQL Client/Server only.
The function HCheckMemo is faster than the function HIndex used with the constant hCheckMemo.
If a problem is detected, you can use HIndex with the hCheckMemo constant.

Component: wd260hf.dll