<Source>.RecordToString (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

<Source>.RecordToString (Function)

In french: <Source>.EnregistrementVersChaîne

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

Example

Enreg is string = Client.EnregistrementVersChaîne()

// Récupère la chaîne contenant la totalité de l'enregistrement
MonEnregistrement is string = Client.EnregistrementVersChaîne()
// Extrait le nom du client
NomClient is string = MonEnregistrement.ExtractString(1)
// Extrait le prénom du client
PrénomClient is string = MonEnregistrement.ExtractString(2)

Syntax

Convert the contents of a record for the specified data file into a string 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 <Format> specified, this character string is in ANSI (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.
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