|
|
|
|
|
<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 both data files and queries.
sJSON is string
sJSON = Customer.RecordToJSON()
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 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 is an empty string (""), all items are exported (except compound keys, binary and binary memo items) in the order in which they were created in the physical file. 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|