ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Previous versions
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
HInfoMemo (Function)
In french: HInfoMemo
ODBCNot available with this kind of connection
Returns the characteristics of binary and text memos.
Example
HReadFirst(Product, Name)
MemoInfo is string
MemoInfo = HInfoMémo(Product, Name)
// Retrieve the name of source file of memo
FileName is string
FileName = ExtractString(MemoInfo, 2, TAB)
Syntax

Finding out the characteristics of Memo item Hide the details

<Result> = HInfoMemo(<Data file> , <Memo item>)
<Result>: Character string
  • Information about the binary memo.
  • Empty string ("") if the memo is empty.
The information is separated by TAB characters. This information is as follows:
<Type>+TAB+<Name>+TAB+<Size>+TAB+<Date>+TAB+<Time>+TAB+<Info>
TypeType of memo. This parameter can take the following values: "TXT" for the text memos, "IMG", "WAV", "OLE", "BIN" or "BAD" ("BAD" indicates that the binary memo is not stored properly)
NameName of source file as it was specified in HLinkMemo.
SizeSize of source file in bytes. For a text memo, this size is expressed in number of characters.
DateDate of source file in "YYYYMMDD" format.
TimeTime of source file in "HHMMSS" format
InfoUser information as it was specified in HLinkMemo

If the memo is a text memo, the name, the date, the time and the user information are not filled. The type is set to "TXT".
Example of value returned by a text memo whose size is 25: "TXT"+TAB+TAB+25+TAB+TAB+TAB.

If the memo is a binary memo that was not assigned by HLinkMemo, the name, date, time and information are not specified. The type is set to "BIN".
Example of value returned by a binary memo whose size is 1202: "BIN"+TAB+TAB+1202+TAB+TAB+TAB.
OLE DBNative Connectors (Native Accesses) The information about the memo will not be saved. The only information returned by HInfoMemo corresponds to:
  • the size of memo,
  • an empty string ("") if there is no size.
For example: "TXT" (or "BIN")+TAB+TAB+25+TAB+TAB+TAB.
<Data file>: Character string
Name of data file (query of view) used.
<Memo item>: Character string
Name of memo item to use.
WINDEVWEBDEV - Server code

Finding out the characteristics of Memo item (Record variable) Hide the details

<Result> = HInfoMemo(<Memo item>)
<Result>: Character string
  • Information about the binary memo.
  • Empty string ("") if the memo is empty.
The information is separated by TAB characters. This information is as follows:
Type+TAB+NAME+TAB+Size+TAB+Date+TAB+Time+TAB+Info
TypeType of memo. This parameter can take the following values: "TXT" for the text memos, "IMG", "WAV", "OLE", "BIN" or "BAD" ("BAD" indicates that the binary memo is not stored properly).
NameName of source file as it was specified in HLinkMemo.
SizeSize of source file in bytes. For a text memo, this size is expressed in number of characters.
DateDate of source file in "YYYYMMDD" format.
TimeTime of source file in "HHMMSS" format
InfoUser information as it was specified in HLinkMemo.

If the memo is a text memo, the name, the date, the time and the user information are not filled. The type is set to "TXT".
Example of value returned by a text memo whose size is 25: "TXT"+TAB+TAB+25+TAB+TAB+TAB.

If the memo is a binary memo that was not assigned by HLinkMemo, the name, date, time and information are not specified. The type is set to "BIN".
Example of value returned by a binary memo whose size is 1202: "BIN"+TAB+TAB+1202+TAB+TAB+TAB.
OLE DBNative Connectors (Native Accesses) The information about the memo will not be saved. The only information returned by HInfoMemo corresponds to:
  • the size of memo,
  • an empty string ("") if there is no size.
For example: "TXT" (or "BIN")+TAB+TAB+25+TAB+TAB+TAB.
<Memo item>: Record variable
Name of memo item to handle via the Record variable. Use the following notation: <Name of record variable>.<Name of memo item>.
Remarks

Previous versions

This function replaces BinaryInfo, which is kept for compatibility with WINDEV 5.5.
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