<Source>.RecordToJSON (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

ErrorStatusModification

FilterIncludedBetween

MigrateLinkedCompositeKey

New WINDEV, WEBDEV, WINDEV Mobile 25 feature!

Array items

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.RecordToJSON (Function)

In french: <Source>.EnregistrementVersJSON

Retrieves the structure and value of the current record and exports them into a string in JASON format.

Remark: This function can be used on the data files and on the queries. Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

New in version 22

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

Example

// Export current record of "Customer"
sJSON is string
sJSON = Customer.RecordToJSON()

// Export current record of "Customer"
// Note: only the NAME and NUMBER items are taken into account
sJSON is string
sJSON = Customer.RecordToJSON("NAME,NUMBER")

Syntax

<Result> = <Source>.RecordToJSON([<List of items>])

<Result>: Character string

Structure and value of the current record in JSON format. This structure has the following format:

{"File":
{
"Item1":Data of item 1,
"Item2":Data of item 2,
...
}
}

<Source>: Type corresponding to the specified source

Name of the HFSQL data file or query used.

<List of items>: Optional character string (with quotes)

Items to export.
If several items are specified, the name of the items must be separated by a comma.
Composite key, binary memo or binary items are ignored.
If this parameter is not specified or if it corresponds to an empty string (""), all the items are exported (except Composite Key items, Binary Memo items and Binary items) in the physical order of description.

Remarks

Array items

If one of the exported items is an array item, each element of the array item is exported in a new level:

{"File":
{
"Item1":Data of item 1,
"Item2":Data of item 2,
"ArrItem":
[Data element 1, Data element 2, ...]
...
}
}

Reminder: Composite key, binary memo or binary items are ignored.

Component : wd250hf.dll