HExtractMemo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Binary Memo item that is using HFSQL thumbnails

Managing memos in SQLite

See also

ExecuteSQLQueryAsynchronous

ExécuteRequêteAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Binary Memo item that is using HFSQL thumbnails
Managing memos in SQLite

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HExtractMemo (Function)

In french: HExtraitMémo

Not available with this kind of connection

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).

Versions 15 and later

This function is now available for Android applications.

New in version 15

This function is now available for Android applications.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Example

See additional examples

HExtractMemo(Customer, Photo, "C:\temp\Photo.gif")

// Photo of product
IF HExtractMemo(SQLGetMemo("MyQuery", 2), "Product.BMP") = False THEN
RESULT False
END

HExtractMemo(Customer, Photo, "\temp\Photo.gif")

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 occurred. HError is used to identify the error.

<Data file>: Character string (with or without quotes)

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 management function (function starting with "H").

<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.
This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.
This parameter must necessarily be specified.

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.
This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.

Versions 19 and later

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 occurred. 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 (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.
This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.

New in version 19

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 occurred. 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 (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.
This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.

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 occurred. 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 (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.
This parameter is mandatory because the name of the source file is not saved in the OLE DB memos.

Remarks

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.

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 : wd260hf.dll