PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HInfoMemo (Function)
In French: HInfoMémo
ODBCNot available with this kind of connection
Returns the characteristics of binary and text memos.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 20 and later
Android This function is now available for the Android applications (for the HFSQL data files).
Java This function is now available for the Java applications (for the HFSQL data files).
Android Widget This function is now available in Android Widget mode (for the HFSQL data files).
New in version 20
Android This function is now available for the Android applications (for the HFSQL data files).
Java This function is now available for the Java applications (for the HFSQL data files).
Android Widget This function is now available in Android Widget mode (for the HFSQL data files).
Android This function is now available for the Android applications (for the HFSQL data files).
Java This function is now available for the Java applications (for the HFSQL data files).
Android Widget This function is now available in Android Widget mode (for the HFSQL data files).
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
HReadFirst(PRODUCT, NAME)
MemoInfo is string
MemoInfo = HInfoMemo(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(<File Name> , <Item Name>)
<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 or BinaryLoad, the name, the date, the time and the information are not filled. 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 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.
<File Name>: Character string (with or without quotes)
Name of data file (query of view) used.
<Item Name>: Character string (with or without quotes)
Name of memo item to use.
Versions 19 and later
WINDEVWEBDEV - Server codeWindows Mobile

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 or BinaryLoad, the name, the date, the time and the information are not filled. 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 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
Memo item to handle via the Record variable. Use the following notation: <Name of Record Variable>.<Name of Memo Item>.
New in version 19
WINDEVWEBDEV - Server codeWindows Mobile

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 or BinaryLoad, the name, the date, the time and the information are not filled. 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 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
Memo item to handle via the Record variable. Use the following notation: <Name of Record Variable>.<Name of Memo Item>.
WINDEVWEBDEV - Server codeWindows Mobile

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 or BinaryLoad, the name, the date, the time and the information are not filled. 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 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
Memo item to handle via the Record variable. Use the following notation: <Name of Record Variable>.<Name of Memo Item>.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment