PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • 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 a HFSQL data file, from a query or from a HFSQL view into a physical file (on disk).
Versions 15 and later
Android This function is now available for the Android applications.
New in version 15
Android This function is now available for the Android applications.
Android This function is now available for the Android applications.
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
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
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.
WINDEVWEBDEV - Server codeReports and QueriesJavaPHPAjaxUser code (UMC)
HExtractMemo(Customer, Photo, "C:\temp\Photo.gif")
WINDEVWEBDEV - Server codeReports and QueriesJavaPHPAjaxUser code (UMC)
// Photo of product
IF HExtractMemo(SQLGetMemo("MyQuery", 2), "Product.BMP") = False THEN
RESULT False
END
Windows Mobile
HExtractMemo(Customer, Photo, "\temp\Photo.gif")
Syntax

Extracting a memo Hide the details

<Result> = HExtractMemo(<File Name> , <Name of Memo Item> [, <Destination File>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<File Name>: Character string (with or without quotes)
Name of data file (query of view) used. If this name is not specified, HExtractMemo handles the last data file used by the last function for HFSQL management (starting with the letter H).
<Name of 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 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 QueriesJavaAjaxUser code (UMC)

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 occurred. HError is used to identify the error.
<Binary memo>: Character string (with or without quotes)
Binary memo returned by SQLGetMemo.
<Destination File>: Character string (with or without quotes)
Path and full name of the file where the content of the item must be saved.
OLE DBNative Accesses This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.
Versions 19 and later
WINDEVWEBDEV - Server codeWindows Mobile

Extracting a memo from a Record variable Hide the details

<Result> = HExtractMemo(<Name of Memo Item> [, <Destination File>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<Name of 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 (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 Accesses This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.
New in version 19
WINDEVWEBDEV - Server codeWindows Mobile

Extracting a memo from a Record variable Hide the details

<Result> = HExtractMemo(<Name of Memo Item> [, <Destination File>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<Name of 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 (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 Accesses This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.
WINDEVWEBDEV - Server codeWindows Mobile

Extracting a memo from a Record variable Hide the details

<Result> = HExtractMemo(<Name of Memo Item> [, <Destination File>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<Name of 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 (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 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 QueriesiPhone/iPadWindows MobileUniversal Windows 10 AppAjaxUser code (UMC)HFSQLHFSQL Client/ServerStored procedures

Binary Memo item that is using HFSQL thumbnails

To extract the content of a HFSQL thumbnail from a HFSQL item, use ..Thumbnail.
See HFSQL thumbnails for more details.
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.
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