ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HRetrieveRecord (Function)
In french: HRécupèreEnregistrement
ODBCNot 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, ...).
Example
Enreg is string = HRécupèreEnregistrement(Client)
// Récupère la chaîne contenant la totalité de l'enregistrement
MonEnregistrement is string = HRécupèreEnregistrement(Client)
// Extrait le nom du client
NomClient is string = ExtractString(MonEnregistrement, 1)
// Extrait le prénom du client
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.
WINDEVWEBDEV - Server code

Retrieving the content of a record for the specified Record variable Hide the details

<Result> = HRetrieveRecord(<Record> [, <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.
<Record>: Optional Record variable
Name of the Record variable used.
<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
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help