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
HSetMemo (Function)
In french: HGèreMémo
ODBCNot available with this kind of connection
Used to modify the management mode of memo items. You have the ability to manage all the memos of a data file or a specific memo item of a data file. The management of memos is enabled by default.
Hyper File 5.5 The management of memos can be implemented for the data file only: the memos cannot be managed for the items.
OLE DB When HSetMemo is called, all started iterations are closed. The filter and search criteria are kept.
Example
// Disable management of memos on observations of the Customer data file
HSetMemo(Customer, Item_Observations, hMemoNo)
Syntax
<Result> = HSetMemo([<Data file> [, <Memo item>, ]] <Management mode>)
<Result>: Integer
Old memo management mode used (before calling HSetMemo).
hMemoAuto
(default value)
The memos are read during the access to the item.
hMemoNoNo management of memos (no read or write operation will be performed on the data file or in the specified item).
hMemoYesThe text memos are read whenever the record is read.
The binary memos are read during the access to the item.
<Data file>: Optional character string
Name of the data file used.
If this name is not specified or if it is equal to "*", all the memo files are taken into account.
<Memo item>: Optional character string
Name of the memo item to manage or not.
If this name is not specified or if it is equal to "*", all the memo items are taken into account.
Hyper File 5.5 The management of memos can be implemented for the data file only: the memos cannot be managed for the items.
<Management mode>: Integer constant
Management mode of the memo items:
hMemoAuto
(default value)
The memos are read during the access to the item.
hMemoNoNo management of memos (no read or write operation will be performed on the data file or in the specified item).
hMemoYesThe text memos are read whenever the record is read.
The binary memos are read during the access to the item.

If only this parameter is specified, the management mode is applied to all the data files and to all the items.
OLE DB The hMemoAuto constant is equivalent to the hMemoYes constant.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help