ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
Example
Rec is string = HRecordToString(Customer)
// Retrieves the string containing the entire record
MyRecord is string = HRecordToString(Customer)
// Extracts the last name of the customer
CustomerLastName is string = ExtractString(MyRecord, 1)
// Extracts the first name of the customer
CustomerFirstName is string = ExtractString(MyRecord, 2)
Syntax

Converting the content of a record to string for the specified file Hide the details

<Result> = HRecordToString([<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 specified <Format>, this character string is in ANSI format (default) or Unicode format.
<Data file>: Optional character string
Name of the data file (view or query) used. If this name is not specified, HRecordToString 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.
Caution: for backward compatibility wit WINDEV 5.5, the separators are not indicated when the array items 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 get a Unicode format string, use the following constant:
hUnicode<Result> is a Unicode character string.
WINDEVWEBDEV - Server code

Converting the content of a record to string for the specified Record variable Hide the details

<Result> = HRecordToString(<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 specified <Format>, this character string is in ANSI format (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.
Caution: for backward compatibility wit WINDEV 5.5, the separators are not indicated when the array items 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 get a Unicode format string, use the following constant:
hUnicode<Result> 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: wd290hf.dll
Minimum version required
  • Version 26
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help