ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Array items
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
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.
Example
// Export current record of the last data file used
sJSON is string = HRecordToJSON()
// Export current record of "Customer"
sJSON is string
sJSON = HRecordToJSON(Customer)
// Export current record of "Customer"
// Remark: only the NAME and NUMBER items are taken into account
sJSON is string
sJSON = HRecordToJSON(Customer, "NAME,NUMBER")
Syntax
<Result> = HRecordToJSON([<Data file> [, <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,
...
}
}
<Data file>: Optional character string
Name of the HFSQL data file or query used. If this parameter is not specified, the last HFSQL data file used will be taken into account.
<List of items>: Optional character string
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.
Business / UI classification: Business Logic
Component: wd290hf.dll
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help