ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
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
<HFSQL file>.ExportJSONString (Function)
In french: <Fichier HFSQL>.ExporteChaîneJSON
ODBCNative Connectors (Native Accesses)Not available with these kinds of connection
Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string.
Example
// Export all customers
sString is string
sString = CUSTOMER.ExportJSONString()
Syntax
<Result> = <File>.ExportJSONString([<Items to export>] [, <Options> [, <Progress Bar>]])
<Result>: Character string
JSON string.
<File>: Control name
Name of data file, view or query used.
<Items to export>: Optional character string
List of names of items to export. The names are delimited by single quotes and they are separated by commas or CR characters. The names of composite key items, binary items and binary memo items are ignored.
If this parameter is an empty string (""), all of the data file items are exported (except composite key, binary, binary memo, and password items).
<Options>: Optional Integer constant
Specifies the creation mode of JSON file:
hExpBreakableThe export can be interrupted by pressing Esc.
If the export is interrupted, the JSON string is valid and contains only the records exported before the interruption.
hExpNormal
(default value)
Standard operating mode.
<Progress Bar>: Optional control name or window name
Name of the Progress Bar control or window that displays the progress of the JSON string creation.
Remarks
Business / UI classification: Business Logic
Component: wd290hf.dll
Minimum version required
  • Version 27
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/21/2023

Send a report | Local help