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.
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+<Nom>+TAB+<Taille>+TAB+<Date>+TAB+<Heure>+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 the original file as given in the HLinkMemo function. | 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.
<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 New in version 19
This page is also available for…
|
|
|