HRecordToString (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HRecordToString (Function)

In french: HEnregistrementVersChaîne

Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).

Example

Enreg is string = HRecordToString(Client)

// Récupère la chaîne contenant la totalité de l'enregistrement
MonEnregistrement is string = HRecordToString(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

Convert the contents of a record for the specified data file into a string 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 <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, 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.
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.

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 <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