PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

  • Array items
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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. Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Exporte l'enregistrement en cours du fichier de données "Client"
sJSON est une chaîne
sJSON = Client.EnregistrementVersJSON()
// Exporte l'enregistrement en cours du fichier de données "Client"
// Remarque: seules les rubriques NOM et NUMERO sont prises en compte
sJSON est une chaîne
sJSON = Client.EnregistrementVersJSON("NOM,NUMERO")
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:
{"Fichier":
{
"Rubrique1":Donnée de la rubrique 1,
"Rubrique2":Donnée de la rubrique 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 is an empty string (""), all fields are exported (except compound key, binary memo, or binary fields) 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:
{"Fichier":
{
"Rubrique1":Donnée de la rubrique 1,
"Rubrique2":Donnée de la rubrique 2,
"RubriqueTab":
[Donnée élément 1, Donnée élément 2, ...]
...
}
}

Reminder: Composite key, binary memo or binary items are ignored.
Component: wd260hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment