ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Your version: 01F250083H (WINDEV 25)

New WINDEV, WEBDEV and WINDEV Mobile 25 feature!
Help / WLanguage / Database management / HFSQL functions / HFSQL functions / 
  • Binary Memo item that is using HFSQL thumbnails
  • Managing memos in SQLite
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
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).
Example
WINDEVJavaUser code (UMC)
Customer.ExtractMemo(Photo, "C:\temp\Photo.gif")
Syntax

Extracting a memo Hide the details

<Result> = <Source>.ExtractMemo(<Memo item> [, <Destination file>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<Source>: Type corresponding to the specified source
Name of data file (query of view) used.
<Memo item>: Character string (with or without quotes)
Name of the item containing the binary memo to extract.
<Destination file>: Optional character string (with quotes)
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
WINDEVUniversal Windows 10 AppUser code (UMC)HFSQLHFSQL 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.
See HFSQL thumbnails for more details.
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.
Component : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/01/2020

Send a report | Local help