Add( INPUT value AS CHARACTER )
Add( INPUT array-value AS CHARACTER EXTENT ) Add( INPUT value AS COM-HANDLE ) Add( INPUT array-value AS COM-HANDLE EXTENT ) Add( INPUT value AS DATE ) Add( INPUT array-value AS DATE EXTENT ) Add( INPUT value AS DATETIME ) Add( INPUT array-value AS DATETIME EXTENT ) Add( INPUT value AS DATETIME-TZ ) Add( INPUT array-value AS DATETIME-TZ EXTENT ) Add( INPUT value AS DECIMAL ) Add( INPUT array-value AS DECIMAL EXTENT ) Add( INPUT value AS HANDLE ) Add( INPUT array-value AS HANDLE EXTENT ) Add( INPUT value AS INT64 ) Add( INPUT array-value AS INT64 EXTENT ) Add( INPUT value AS INTEGER ) Add( INPUT array-value AS INTEGER EXTENT ) Add( INPUT value AS LOGICAL ) Add( INPUT array-value AS LOGICAL EXTENT ) Add( INPUT value AS LONGCHAR ) Add( INPUT array-value AS LONGCHAR EXTENT ) Add( INPUT value AS MEMPTR ) Add( INPUT value AS CHARACTER ) Add( INPUT array-value AS CHARACTER EXTENT ) Add( INPUT value AS COM-HANDLE ) Add( INPUT array-value AS COM-HANDLE EXTENT ) Add( INPUT value AS DATE ) Add( INPUT array-value AS DATE EXTENT ) Add( INPUT value AS DATETIME ) Add( INPUT array-value AS DATETIME EXTENT ) Add( INPUT value AS DATETIME-TZ ) Add( INPUT array-value AS DATETIME-TZ EXTENT ) Add( INPUT value AS DECIMAL ) Add( INPUT array-value AS DECIMAL EXTENT ) Add( INPUT value AS HANDLE ) Add( INPUT array-value AS HANDLE EXTENT ) Add( INPUT value AS INT64 ) Add( INPUT array-value AS INT64 EXTENT ) Add( INPUT value AS INTEGER ) Add( INPUT array-value AS INTEGER EXTENT ) Add( INPUT value AS LOGICAL ) Add( INPUT array-value AS LOGICAL EXTENT ) Add( INPUT value AS LONGCHAR ) Add( INPUT array-value AS LONGCHAR EXTENT ) Add( INPUT value AS MEMPTR ) Add( INPUT array-value AS MEMPTR EXTENT ) Add( INPUT value AS RAW ) Add( INPUT array-value AS RAW EXTENT ) Add( INPUT value AS RECID ) Add( INPUT array-value AS RECID EXTENT ) Add( INPUT value AS ROWID ) Add( INPUT array-value AS ROWID EXTENT ) Add( INPUT value AS CLASS JsonObject ) Add( INPUT array-value AS CLASS JsonObject EXTENT ) Add( INPUT value AS CLASS JsonArray ) Add( INPUT array-value AS CLASS JsonArray EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS CHARACTER ) Add( INPUT index AS INTEGER, INPUT array-value AS CHARACTER EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS COM-HANDLE ) Add( INPUT index AS INTEGER, INPUT array-value AS COM-HANDLE EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS DATE ) Add( INPUT index AS INTEGER, INPUT array-value AS DATE EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS DATETIME ) Add( INPUT index AS INTEGER, INPUT array-value AS DATETIME EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS DATETIME-TZ ) Add( INPUT index AS INTEGER, INPUT array-value AS DATETIME-TZ EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS DECIMAL ) Add( INPUT index AS INTEGER, INPUT array-value AS DECIMAL EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS HANDLE ) Add( INPUT index AS INTEGER, INPUT array-value AS HANDLE EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS INT64 ) Add( INPUT index AS INTEGER, INPUT array-value AS INT64 EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS INTEGER ) Add( INPUT index AS INTEGER, INPUT array-value AS INTEGER EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS LOGICAL ) Add( INPUT index AS INTEGER, INPUT array-value AS LOGICAL EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS LONGCHAR ) Add( INPUT index AS INTEGER, INPUT array-value AS LONGCHAR EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS MEMPTR ) Add( INPUT index AS INTEGER, INPUT array-value AS MEMPTR EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS RAW ) Add( INPUT index AS INTEGER, INPUT array-value AS RAW EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS RECID ) Add( INPUT index AS INTEGER, INPUT array-value AS RECID EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS ROWID ) Add( INPUT index AS INTEGER, INPUT array-value AS ROWID EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS CLASS JsonObject ) Add( INPUT index AS INTEGER, INPUT array-value AS CLASS JsonObject EXTENT ) Add( INPUT index AS INTEGER, INPUT value AS CLASS JsonArray ) Add( INPUT index AS INTEGER, INPUT array-value AS CLASS JsonArray EXTENT ) |
A value parameter of data type
|
Data type of JSON value
|
CHARACTER, LONGCHAR
|
string
|
INTEGER, INT64, DECIMAL
|
number
|
LOGICAL
|
boolean
|
MEMPTR, RAW, ROWID
|
string with a value as if you had called BASE64-ENCODE( ) on value
|
DATE, DATETIME, DATETIME-TZ
|
string with a value as if you had called ISO-DATE( ) on value
|
COM-HANDLE, HANDLE, RECID
|
number with a value as if you had called INTEGER( ) on value
|
DEFINE VARIABLE a AS INTEGER EXTENT 3 INITIAL [3, 2, 1].
DEFINE VARIABLE b AS CHARACTER EXTENT 2 INITIAL ["Hello", "world"]. DEFINE VARIABLE c AS DATE EXTENT 2 INITIAL ["9/20/10", "10/10/10"]. myArr = NEW JsonArray(a) /* myArr is now [3, 2, 1] */ myArr:Add(TRUE). /* myArr is now [3, 2, 1, true] */ myArr:Add(b). /* myArr is now [3, 2, 1, true, "Hello", "world"] */ myArr:Add(2, c). /* myArr is now [3, 2, "2010-09-20", "2010-10-10", 1, true, "Hello", "world"] */ |