ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
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
Checks the structural integrity of memos in an HFSQL data file.
Example
SI Client.VérifieMémo(JAUGE_Jauge1) <> "" ALORS
Info("Mémo corrompu")
FIN
Syntax
<Result> = <Source>.CheckMemo([<Progress Bar>])
<Result>: Character string
  • Empty string ("") if there is no problem.
  • In case of problem, string in the following format:
    <Rubrique 1> + TAB + <Numéro d'enregistrement 1> + RC + ...
    <Rubrique N> + TAB + <Numéro d'enregistrement N>
    where:
    • <Item X> is the memo item,
    • <Record number> is the number of the record containing the Memo item.
HFSQL Client/Server If the list of free blocks is corrupted, <Result> will contain:
<TAB> + "-1"
<Result> will have the following format:
<TAB> + "-1"+ RC + <Rubrique 1> + TAB + <Numéro d'enregistrement 1> + RC + ...
<Rubrique N> + TAB + <Numéro d'enregistrement N>
<Source>: Type corresponding to the specified source
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.
Remarks
  • The list of free blocks is checked in HFSQL Client/Server only.
  • The function <Source>.CheckMemo is faster than the function <Source>.Index used with the constant hCheckMemo.
  • If a problem is detected, it is possible to use the <Source>.Index function with the hCheckMemoconstant.
  • From version 27 onwards, the memo verification is improved and deepened, which can lead to longer processing times.
Component: wd270hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/21/2023

Send a report | Local help