JsonArray ActiveX Reference Documentation

JsonArray

Current Version: 10.1.2

Represents a JSON array, which contains an ordered list of JSON values, where each value can be a string, number, JSON object, JSON array, true, false, or null.

Object Creation

Note:
For versions of Chilkat < 10.0.0, use "Chilkat_9_5_0.JsonArray" instead of "Chilkat.JsonArray"
For a specific major version, use "Chilkat.JsonArray.<major_version>", such as "Chilkat.JsonArray.10" for Chilkat v10.*.*
See Chilkat ActiveX Object Creation

(ASP)
set obj = Server.CreateObject("Chilkat.JsonArray")

(AutoIt)
$obj = ObjCreate("Chilkat.JsonArray")

(Visual Basic 6.0)
Dim obj As New ChilkatJsonArray

(VBScript)
set obj = CreateObject("Chilkat.JsonArray")

(Delphi)
obj := TChilkatJsonArray.Create(Self);

(FoxPro)
loObject = CreateObject('Chilkat.JsonArray')

(PowerBuilder)
lole_object = create oleobject
li_rc = lole_object.ConnectToNewObject("Chilkat.JsonArray")

(SQL Server)
EXEC @hr = sp_OACreate 'Chilkat.JsonArray', @obj OUT

(Javascript)
var obj = new ActiveXObject("Chilkat.JsonArray");

Properties

DebugLogFilePath

DebugLogFilePath As String

If set to a file path, this property logs the LastErrorText of each Chilkat method or property call to the specified file. This logging helps identify the context and history of Chilkat calls leading up to any crash or hang, aiding in debugging.

Enabling the VerboseLogging property provides more detailed information. This property is mainly used for debugging rare instances where a Chilkat method call causes a hang or crash, which should generally not happen.

Possible causes of hangs include:

A timeout property set to 0, indicating an infinite timeout.
A hang occurring within an event callback in the application code.
An internal bug in the Chilkat code causing the hang.

More Information and Examples

(AutoIt) Example showing how to use DebugLogFilePath.(Classic ASP) Example showing how to use DebugLogFilePath.(PowerBuilder) Example showing how to use DebugLogFilePath.(SQL Server) Example showing how to use DebugLogFilePath.(VBScript) Example showing how to use DebugLogFilePath.(Visual Basic 6.0) Example showing how to use DebugLogFilePath.(Visual FoxPro) Example showing how to use DebugLogFilePath.

EmitCompact

EmitCompact As Long

Introduced in version 9.5.0.64

If 1 then the Emit method outputs in the most compact form possible (a single-line with no extra whitespace). If 0, then emits with whitespace and indentation to make the JSON human-readable.

The default value is 1.

EmitCrlf

EmitCrlf As Long

Introduced in version 9.5.0.64

If 1 then the Emit method uses CRLF line-endings when emitting the non-compact (pretty-print) format. If 0, then bare-LF's are emitted. (The compact format emits to a single line with no end-of-line characters.) Windows systems traditionally use CRLF line-endings, whereas Linux, Mac OS X, and other systems traditionally use bare-LF line-endings.

The default value is 1.

LastBinaryResult

LastBinaryResult As Variant (read-only)

This property is mainly used in SQL Server stored procedures to retrieve binary data from the last method call that returned binary data. It is only accessible if Chilkat.Global.KeepBinaryResult is set to 1. This feature allows for the retrieval of large varbinary results in an SQL Server environment, which has restrictions on returning large data via method calls, though temp tables can handle binary properties.

LastErrorHtml

LastErrorHtml As String (read-only)

Provides HTML-formatted information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

LastErrorText

LastErrorText As String (read-only)

Provides plain text information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

More Information and Examples

Concept of LastErrorText LastErrorText Standard Information

LastErrorXml

LastErrorXml As String (read-only)

Provides XML-formatted information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

LastMethodSuccess

LastMethodSuccess As Long

Indicates the success or failure of the most recent method call: 1 means success, 0 means failure. This property remains unchanged by property setters or getters. This method is present to address challenges in checking for null or Nothing returns in certain programming languages.

LastStringResult

LastStringResult As String (read-only)

In SQL Server stored procedures, this property holds the string return value of the most recent method call that returns a string. It is accessible only when Chilkat.Global.KeepStringResult is set to TRUE. SQL Server has limitations on string lengths returned from methods and properties, but temp tables can be used to access large strings.

More Information and Examples

Long Strings Returned by ActiveX Methods in SQL Server

LastStringResultLen

LastStringResultLen As Long (read-only)

The length, in characters, of the string contained in the LastStringResult property.

Size

Size As Long (read-only)

Introduced in version 9.5.0.56

The number of JSON values in the array.

VerboseLogging

VerboseLogging As Long

If set to 1, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. The default value is 0. Verbose logging should only be used for debugging. The potentially large quantity of logged information may adversely affect peformance.

Version

Version As String (read-only)

Version of the component/library, such as "10.1.0"

More Information and Examples

(AutoIt) How to get the Chilkat version at runtime.(Classic ASP) How to get the Chilkat version at runtime.(PowerBuilder) How to get the Chilkat version at runtime.(SQL Server) How to get the Chilkat version at runtime.(VBScript) How to get the Chilkat version at runtime.(Visual Basic 6.0) How to get the Chilkat version at runtime.(Visual FoxPro) How to get the Chilkat version at runtime.

Methods

AddArrayAt

AddArrayAt(ByVal index As Long) As Long

Introduced in version 9.5.0.56

Inserts a new and empty JSON array member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

AddBoolAt

AddBoolAt(ByVal index As Long, ByVal value As Long) As Long

Introduced in version 9.5.0.56

Inserts a new boolean member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

AddIntAt

AddIntAt(ByVal index As Long, ByVal value As Long) As Long

Introduced in version 9.5.0.56

Inserts a new integer member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

AddNullAt

AddNullAt(ByVal index As Long) As Long

Introduced in version 9.5.0.56

Inserts a new null member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

AddNumberAt

AddNumberAt(ByVal index As Long, numericStr As String) As Long

Introduced in version 9.5.0.56

Inserts a new numeric member to the position indicated by index. The numericStr is an integer, float, or double already converted to a string in the format desired by the application. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Create more Complex JSON Document (Classic ASP) Create more Complex JSON Document (PowerBuilder) Create more Complex JSON Document (SQL Server) Create more Complex JSON Document (VBScript) Create more Complex JSON Document (Visual Basic 6.0) Create more Complex JSON Document (Visual FoxPro) Create more Complex JSON Document (AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

AddObjectAt

AddObjectAt(ByVal index As Long) As Long

Introduced in version 9.5.0.56

Inserts a new and empty JSON object member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Create more Complex JSON Document (Classic ASP) Create more Complex JSON Document (PowerBuilder) Create more Complex JSON Document (SQL Server) Create more Complex JSON Document (VBScript) Create more Complex JSON Document (Visual Basic 6.0) Create more Complex JSON Document (Visual FoxPro) Create more Complex JSON Document (AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

AddObjectCopyAt

AddObjectCopyAt(ByVal index As Long, jsonObj As ChilkatJsonObject) As Long

Introduced in version 9.5.0.82

Inserts a copy of a JSON object to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) JSON Array AddObjectCopyAt Example (Classic ASP) JSON Array AddObjectCopyAt Example (PowerBuilder) JSON Array AddObjectCopyAt Example (SQL Server) JSON Array AddObjectCopyAt Example (VBScript) JSON Array AddObjectCopyAt Example (Visual Basic 6.0) JSON Array AddObjectCopyAt Example (Visual FoxPro) JSON Array AddObjectCopyAt Example

AddStringAt

AddStringAt(ByVal index As Long, value As String) As Long

Introduced in version 9.5.0.56

Inserts a new string at the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Create more Complex JSON Document (Classic ASP) Create more Complex JSON Document (PowerBuilder) Create more Complex JSON Document (SQL Server) Create more Complex JSON Document (VBScript) Create more Complex JSON Document (Visual Basic 6.0) Create more Complex JSON Document (Visual FoxPro) Create more Complex JSON Document (AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

AddUIntAt

AddUIntAt(ByVal index As Long, ByVal value As Long) As Long

Introduced in version 9.5.0.96

Inserts a new unsigned integer member to the position indicated by index. To prepend, pass an index of 0. To append, pass an index of -1. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

AppendArrayItems

AppendArrayItems(jarr As ChilkatJsonArray) As Long

Introduced in version 9.5.0.82

Appends the array items contained in jarr.

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) AppendArrayItems Example (Classic ASP) AppendArrayItems Example (PowerBuilder) AppendArrayItems Example (SQL Server) AppendArrayItems Example (VBScript) AppendArrayItems Example (Visual Basic 6.0) AppendArrayItems Example (Visual FoxPro) AppendArrayItems Example

ArrayAt

ArrayAt(ByVal index As Long) As ChilkatJsonArray

Introduced in version 9.5.0.56

Returns the JSON array that is the value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns Nothing on failure

More Information and Examples

(AutoIt) JSON: Nested Array (Classic ASP) JSON: Nested Array (PowerBuilder) JSON: Nested Array (SQL Server) JSON: Nested Array (VBScript) JSON: Nested Array (Visual Basic 6.0) JSON: Nested Array (Visual FoxPro) JSON: Nested Array

BoolAt

BoolAt(ByVal index As Long) As Long

Introduced in version 9.5.0.56

Returns the boolean value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Clear

Clear()

Introduced in version 9.5.0.76

Deletes all array elements.

DateAt

DateAt(ByVal index As Long, dateTime As CkDateTime) As Long

Introduced in version 9.5.0.73

Fills the dateTime with the date/time string located in the Nth array element. Indexing is 0-based (the 1st member is at index 0). Auto-recognizes the following date/time string formats: ISO-8061 Timestamp (such as "2009-11-04T19:55:41Z"), RFC822 date/time format (such as "Wed, 18 Apr 2018 15:51:55 -0400"), or Unix timestamp integers.

Returns 1 for success, 0 for failure.

DeleteAt

DeleteAt(ByVal index As Long) As Long

Introduced in version 9.5.0.56

Deletes the array element at the given index. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

DtAt

DtAt(ByVal index As Long, ByVal bLocal As Long, dt As DtObj) As Long

Introduced in version 9.5.0.73

Fills the dt with the date/time string located in the Nth array element. If bLocal is 1, then dt is filled with the local date/time values, otherwise it is filled with the UTC/GMT values. Indexing is 0-based (the 1st member is at index 0). Auto-recognizes the following date/time string formats: ISO-8061 Timestamp (such as "2009-11-04T19:55:41Z"), RFC822 date/time format (such as "Wed, 18 Apr 2018 15:51:55 -0400"), or Unix timestamp integers.

Returns 1 for success, 0 for failure.

Emit

Emit() As String

Introduced in version 9.5.0.58

Writes the JSON array (rooted at the caller) and returns as a string.

Note: To control the compact/non-compact format, and to control the LF/CRLF line-endings, set the EmitCompact and EmitCrlf properties.

Returns Nothing on failure

EmitSb

EmitSb(sb As ChilkatStringBuilder) As Long

Introduced in version 9.5.0.65

Writes the JSON array to the sb.

Note: To control the compact/non-compact format, and to control the LF/CRLF line-endings, set the EmitCompact and EmitCrlf properties.

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Emit JSON Array to StringBuilder (Classic ASP) Emit JSON Array to StringBuilder (PowerBuilder) Emit JSON Array to StringBuilder (SQL Server) Emit JSON Array to StringBuilder (VBScript) Emit JSON Array to StringBuilder (Visual Basic 6.0) Emit JSON Array to StringBuilder (Visual FoxPro) Emit JSON Array to StringBuilder

FindObject

FindObject(name As String, value As String, ByVal caseSensitive As Long) As Long

Introduced in version 9.5.0.73

Return the index of the first object in the array where value of the field at name matches value. name is an object member name. The value is a value pattern which can use "*" chars to indicate zero or more of any char. If caseSensitive is 0, then the matching is case insenstive, otherwise it is case sensitive. Returns -1 if no matching string was found.

More Information and Examples

(AutoIt) Find and Delete Object from JSON Array (Classic ASP) Find and Delete Object from JSON Array (PowerBuilder) Find and Delete Object from JSON Array (SQL Server) Find and Delete Object from JSON Array (VBScript) Find and Delete Object from JSON Array (Visual Basic 6.0) Find and Delete Object from JSON Array (Visual FoxPro) Find and Delete Object from JSON Array

FindString

FindString(value As String, ByVal caseSensitive As Long) As Long

Introduced in version 9.5.0.73

Return the index of the first matching string in the array. The value is a value pattern which can use "*" chars to indicate zero or more of any char. If caseSensitive is 0, then the matching is case insenstive, otherwise it is case sensitive. Returns -1 if no matching string was found.

IntAt

IntAt(ByVal index As Long) As Long

Introduced in version 9.5.0.56

Returns the integer value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

More Information and Examples

(AutoIt) JSON: Access Array Values (Classic ASP) JSON: Access Array Values (PowerBuilder) JSON: Access Array Values (SQL Server) JSON: Access Array Values (VBScript) JSON: Access Array Values (Visual Basic 6.0) JSON: Access Array Values (Visual FoxPro) JSON: Access Array Values

IsNullAt

IsNullAt(ByVal index As Long) As Long

Introduced in version 9.5.0.56

Returns the 1 if the Nth array element is null, otherwise returns 0. Indexing is 0-based (the 1st member is at index 0).

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

Load

Load(jsonArray As String) As Long

Introduced in version 9.5.0.64

Loads a JSON array from a string. A JSON array must begin with a "[" and end with a "]".

Note: The Load method causes the JsonArray to detach and become it's own JSON document. It should only be called on new instances of the JsonArray. See the example below.

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Load a JsonArray (Classic ASP) Load a JsonArray (PowerBuilder) Load a JsonArray (SQL Server) Load a JsonArray (VBScript) Load a JsonArray (Visual Basic 6.0) Load a JsonArray (Visual FoxPro) Load a JsonArray (AutoIt) Loading and Parsing a JSON Array (Classic ASP) Loading and Parsing a JSON Array (PowerBuilder) Loading and Parsing a JSON Array (SQL Server) Loading and Parsing a JSON Array (VBScript) Loading and Parsing a JSON Array (Visual Basic 6.0) Loading and Parsing a JSON Array (Visual FoxPro) Loading and Parsing a JSON Array (AutoIt) Understanding JSON Array vs JSON Object (Classic ASP) Understanding JSON Array vs JSON Object (PowerBuilder) Understanding JSON Array vs JSON Object (SQL Server) Understanding JSON Array vs JSON Object (VBScript) Understanding JSON Array vs JSON Object (Visual Basic 6.0) Understanding JSON Array vs JSON Object (Visual FoxPro) Understanding JSON Array vs JSON Object

LoadSb

LoadSb(sb As ChilkatStringBuilder) As Long

Introduced in version 9.5.0.64

Loads a JSON array from a StringBuilder. A JSON array must begin with a "[" and end with a "]".

Note: The Load method causes the JsonArray to detach and become it's own JSON document. It should only be called on new instances of the JsonArray. See the example below.

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Load a JsonArray (Classic ASP) Load a JsonArray (PowerBuilder) Load a JsonArray (SQL Server) Load a JsonArray (VBScript) Load a JsonArray (Visual Basic 6.0) Load a JsonArray (Visual FoxPro) Load a JsonArray

ObjectAt

ObjectAt(ByVal index As Long) As ChilkatJsonObject

Introduced in version 9.5.0.56

Returns the JSON object that is the value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns Nothing on failure

More Information and Examples

(AutoIt) JSON: Array of Objects (Classic ASP) JSON: Array of Objects (PowerBuilder) JSON: Array of Objects (SQL Server) JSON: Array of Objects (VBScript) JSON: Array of Objects (Visual Basic 6.0) JSON: Array of Objects (Visual FoxPro) JSON: Array of Objects (AutoIt) Create more Complex JSON Document (Classic ASP) Create more Complex JSON Document (PowerBuilder) Create more Complex JSON Document (SQL Server) Create more Complex JSON Document (VBScript) Create more Complex JSON Document (Visual Basic 6.0) Create more Complex JSON Document (Visual FoxPro) Create more Complex JSON Document (AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

SetBoolAt

SetBoolAt(ByVal index As Long, ByVal value As Long) As Long

Introduced in version 9.5.0.56

Sets the boolean value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

SetIntAt

SetIntAt(ByVal index As Long, ByVal value As Long) As Long

Introduced in version 9.5.0.56

Sets the integer value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

SetNullAt

SetNullAt(ByVal index As Long) As Long

Introduced in version 9.5.0.56

Sets the Nth array element to the value of null. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

SetNumberAt

SetNumberAt(ByVal index As Long, value As String) As Long

Introduced in version 9.5.0.56

Sets the numeric value of the Nth array element. The value is an integer, float, or double already converted to a string in the format desired by the application. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

SetStringAt

SetStringAt(ByVal index As Long, value As String) As Long

Introduced in version 9.5.0.56

Sets the string value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

More Information and Examples

(AutoIt) Modify Parts of JSON Document (Classic ASP) Modify Parts of JSON Document (PowerBuilder) Modify Parts of JSON Document (SQL Server) Modify Parts of JSON Document (VBScript) Modify Parts of JSON Document (Visual Basic 6.0) Modify Parts of JSON Document (Visual FoxPro) Modify Parts of JSON Document

SetUIntAt

SetUIntAt(ByVal index As Long, ByVal value As Long) As Long

Introduced in version 9.5.0.96

Sets the unsigned integer value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns 1 for success, 0 for failure.

StringAt

StringAt(ByVal index As Long) As String

Introduced in version 9.5.0.56

Returns the string value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).

Returns Nothing on failure

More Information and Examples

(AutoIt) JSON: Access Array Values (Classic ASP) JSON: Access Array Values (PowerBuilder) JSON: Access Array Values (SQL Server) JSON: Access Array Values (VBScript) JSON: Access Array Values (Visual Basic 6.0) JSON: Access Array Values (Visual FoxPro) JSON: Access Array Values

Swap

Swap(ByVal index1 As Long, ByVal index2 As Long) As Long

Introduced in version 9.5.0.76

Swaps the items at positions index1 and index2.

Returns 1 for success, 0 for failure.

TypeAt

TypeAt(ByVal index As Long) As Long

Introduced in version 9.5.0.58

Returns the type of data at the given index. Possible return values are:

string
number
object
array
boolean
null

Returns -1 if no member exists at the given index.

UIntAt

UIntAt(ByVal index As Long) As Long

Introduced in version 9.5.0.96

Returns the unsigned integer value of the Nth array element. Indexing is 0-based (the 1st member is at index 0).