ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Binary Memo item that is using HFSQL thumbnails
  • Managing memos in SQLite
  • 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
Extracts the content of a binary memo item from an HFSQL data file, from a query or from an HFSQL view into a physical file (on disk).
WINDEVWEBDEV - Server codeReports and QueriesJavaUser code (UMC)PHPAjax
HExtractMemo(Customer, Photo, "C:\temp\Photo.gif")
WINDEVWEBDEV - Server codeReports and QueriesJavaUser code (UMC)PHPAjax
// Product image
IF HExtractMemo(SQLGetMemo("MyQuery", 2), "Product.BMP") = False THEN
RESULT False
END
Syntax

Extracting a memo Hide the details

<Result> = HExtractMemo(<Data file> , <Memo item> [, <Destination file>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
<Data file>: Character string
Name of data file (query of view) used. If this name is not specified, HExtractMemo will use the last data file used by the last HFSQL function (function starting with "H").
<Memo item>: Character string
Name of the item containing the binary memo to extract.
<Destination file>: Optional character string
Path and full name of the file where the content of the item must be saved. If this parameter is not specified, the binary memo is saved in its initial path and file. The creation date and the date of last modification of this file are restored.
OLE DBNative Connectors (Native Accesses) This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.
AndroidAndroid Widget PHP This parameter must necessarily be specified.
WINDEVWEBDEV - Server codeReports and QueriesJavaUser code (UMC)Ajax

Extracting a memo (syntax for SQLGetMemo) Hide the details

<Result> = HExtractMemo(<Binary Memo> , <Destination file>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
<Binary Memo>: Character string
Binary memo returned by SQLGetMemo.
<Destination file>: Character string
Path and full name of the file where the content of the item must be saved.
OLE DBNative Connectors (Native Accesses) This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.
WINDEVWEBDEV - Server code

Extracting a memo from a Record variable Hide the details

<Result> = HExtractMemo(<Memo item> [, <Destination file>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
<Memo item>: Record variable
Name of the item containing the binary memo to extract. Use the following notation: <Name of Record variable>.<Name of Memo item>.
<Destination file>: Optional character string
Path and full name of the file where the content of the item must be saved. If this parameter is not specified, the binary memo is saved in its initial path and file. The creation date and the date of last modification of this file are restored.
OLE DBNative Connectors (Native Accesses) This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.
Remarks
WINDEVWEBDEV - Server codeReports and QueriesUniversal Windows 10 AppiPhone/iPadUser code (UMC)AjaxHFSQL ClassicHFSQL Client/ServerStored procedures

Binary Memo item that is using HFSQL thumbnails

To extract the content of an HFSQL thumbnail from an HFSQL item, use Thumbnail.
For more details, see HFSQL thumbnails.
Native Connectors (Native Accesses)

Managing memos in SQLite

Storing information in memo format is recommended for the data whose size is less than 1 MB. We advise you to directly save the data in external file format on the internal or external memory of the phone and to store the access path to this data in the database.
WINDEV

Previous versions

This function replaces BinarySave, 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/31/2022

Send a report | Local help