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 = Customer.RecordToString()
// Retrieves the string containing the entire record
MyRecord is string = Customer.RecordToString()
// Extracts the last name of the customer
CustomerLastName is string = MyRecord.ExtractString(1)
// Extracts the first name of the customer
CustomerFirstName is string = MyRecord.ExtractString(2)
Syntax

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

<Result> = <Source>.RecordToString([<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.
<Source>: Type corresponding to the specified source
Name of the data file (view or query) used. If this name is not specified, <Source>.RecordToString 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.
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: 06/21/2023

Send a report | Local help