ExportRowAsJson

Description

Exports a data row from the specified buffer of a DataWindow control, DataStore object, or DataWindowChild object to the JSON string. The exported JSON string will be a one-level plain JSON string. For details, see Plain JSON: one-level structure in Application Techniques.

Applies to

DataWindow type

Method applies to

PowerBuilder

DataWindow control, DataWindowChild object, and DataStore object, except for those with the Composite, Crosstab, OLE 2.0, or RichText presentation styles.


Syntax

PowerBuilder

string dwcontrol.ExportRowAsJson (long row {, DWBuffer dwbuffer})

Argument

Description

dwcontrol

A reference to a DataWindow control, DataStore, or DataWindowChild.

row

A long value identifying the row of data to be exported. 1 indicates the first row. The following number is invalid: 0, a negative value, or a value greater than the row count.

dwbuffer (optional)

A value of the dwBuffer enumerated datatype identifying the DataWindow buffer from which you want to export the data. For a list of valid values, see DWBuffer. If not specified, exports the data from the Primary! buffer. If specified, exports the data from the specified buffer.


Return value

String. Returns the JSON string if the data row was exported successfully. Returns the empty string ("") if an error occurs or illegal row number (0, a negative value, or a value greater than the DataWindow row count) is specified.

The method returns null if any of the following:

  • any argument's value is null

  • the DataWindow object (dataobject) is invalid

  • the DataWindow presentation style is unsupported, such as Composite, Crosstab, OLE 2.0, or RichText

Example

The following example exports the last row of data from the delete buffer.

String ls_ExportRowAsJson
If dw_Data.GetRow() > 0 Then
 ls_ExportRowAsJson = dw_Data.ExportRowAsJson(dw_Data.GetRow())
 
 // Exports the last row in delete buffer
 dw_Data.DeleteRow(dw_Data.GetRow())
 ls_ExportRowAsJson = dw_Data.ExportRowAsJson ( dw_Data.DeletedCount( ), Delete! )
End If

See also

ImportRowFromJson