HInfoMemo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

ExecuteQueryAsynchronous

ExecuteSQLQueryAsynchronous

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HInfoMemo (Function)

In french: HInfoMemo

Not available with this kind of connection

Returns the characteristics of binary and text memos.

Remark: 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(<Data file> , <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>

Type Type 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)
Name Name of source file as it was specified in HLinkMemo.
Size Size of source file in bytes. For a text memo, this size is expressed in number of characters.
Date Date of source file in "YYYYMMDD" format.
Time Time of source file in "HHMMSS" format
Info User 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.
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.

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

Name of data file (query of view) used.

<Memo item>: Character string (with or without quotes)

Name of memo item to use.

Versions 19 and later

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

Type Type 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).
Name Name of source file as it was specified in HLinkMemo.
Size Size of source file in bytes. For a text memo, this size is expressed in number of characters.
Date Date of source file in "YYYYMMDD" format.
Time Time of source file in "HHMMSS" format
Info User 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.
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

Name of memo item to handle via the Record variable. Use the following notation: <Name of record variable>.<Name of memo item>.

New in version 19

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

Type Type 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).
Name Name of source file as it was specified in HLinkMemo.
Size Size of source file in bytes. For a text memo, this size is expressed in number of characters.
Date Date of source file in "YYYYMMDD" format.
Time Time of source file in "HHMMSS" format
Info User 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.
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

Name of memo item to handle via the Record variable. Use the following notation: <Name of record variable>.<Name of memo item>.

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

Type Type 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).
Name Name of source file as it was specified in HLinkMemo.
Size Size of source file in bytes. For a text memo, this size is expressed in number of characters.
Date Date of source file in "YYYYMMDD" format.
Time Time of source file in "HHMMSS" format
Info User 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.
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

Name of memo item to handle via the Record variable. Use the following notation: <Name of record variable>.<Name of memo item>.

Component: wd260hf.dll