ExportRowAsJson
method (DataWindows)
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 |
Syntax
PowerBuilder
|
1 |
string dwcontrol.ExportRowAsJson (long row {, DWBuffer dwbuffer}) |
|
Argument |
Description |
|---|---|
|
dwcontrol |
A reference to a DataWindow control, DataStore, or |
|
row |
A long value identifying the row of data to be |
|
dwbuffer (optional) |
A value of the dwBuffer enumerated datatype |
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
Usage
The Number data type is handled as Double data type; 15 digits of
precision is supported; and it will be written in scientific notation if
it exceeds 15 digits.
The Decimal{0} data type is handled as Double data type; it has no
fractional part, and the digits in the fractional part (if any) will be
rounded to the integral part; 15 digits of precision is supported; and it
will be written in scientific notation if it exceeds 15 digits.
The Decimal{n} data type is handled as Double data type; it can have
n digits in the fractional part, and the following digits (if any) will be
rounded; 15 digits of precision is supported; and it will be written in
scientific notation if it exceeds 15 digits.
Example
The following example exports the last row of data from the delete
buffer.
|
1 2 3 4 5 6 7 8 |
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