|
|
|
|
|
|
|
|
|
|
HRetrieveRecord (Function) In french: HRécupèreEnregistrement
 Not available with this kind of connection
 Warning
From version 26, This function is kept for backward compatibility. It is recommended to use HRecordToString.
Returns the content of the current record (in an HFSQL data file, view, query, ...).
Enreg is string = HRécupèreEnregistrement(Client)
MonEnregistrement is string = HRécupèreEnregistrement(Client)
NomClient is string = ExtractString(MonEnregistrement, 1)
PrénomClient is string = ExtractString(MonEnregistrement, 2)
Syntax
Retrieving the content of a record for the specified file Hide the details
<Result> = HRetrieveRecord([<Data file> [, <Item separator> [, <Array separator> [, <Format>]]]])
<Result>: Character string Value of the record, in the following format:
<Content of item 1> + <Item separator> + <Content of item 2> + ... The contents of items are extracted according to the physical order of items in the data file. If the item corresponds to NULL, <Content of item> corresponds to an empty string (""). Depending on the <Format> specified, this character string is in ANSI (default) or Unicode format. <Data file>: Optional character string Name of the data file (view or query) used. If this name is not specified, HRetrieveRecord will use the last data file used by the last HFSQL function (function starting with "H"). <Item separator>: Optional character string Character string used to separate the different items in <Result>. The default separator is TAB. <Array separator>: Optional character string Character string used to separate the values of array items (or sub-items) in <Result>. The default separator is TAB.
Please note: for compatibility with WINDEV 5.5, separators are not shown when array fields are empty. <Format>: Optional Integer constant Format used to return the value of the record. By default, an ANSI format character string is returned. To obtain a string in Unicode format, use the following constant: | | | hUnicode | <Résultat> is a Unicode character string. |
Remarks - The content of Binary Memo items is not retrieved but the item separator is present (to avoid a shift).
- The content of composite keys is not retrieved but the item separator is present (to avoid a shift).
Business / UI classification: Business Logic
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|