Calling convention: CIP_JSON_GetDBValue(JSONObjectPointer: NativeInt, RowIndex: Integer, "FieldName": String, "ValueType": String): Variant
Description: Reads and converts one field value from a JSON dataset created by CIP_JSON_SQL.
Parameters:
JSONObjectPointer = Valid pointer to a JSON dataset.
RowIndex = Zero-based row index.
FieldName = Database field name.
ValueType = STRING, INTEGER, NUMBER, DOUBLE, ARRAY or OBJECT.
Returns: Variant: converted field value; NULL if the constructed field path is absent. Invalid pointers, NULL required arguments or conversion errors raise an exception.
Availability: Default.
Example:
try
JSONSQLObj := CIP_JSON_SQL("", "SELECT * FROM OBJECTS");
ShortName := CIP_JSON_GetDBValue(JSONSQLObj, 0, "ShortName", "STRING");
CIP_AddScreenLog(ShortName);
finally
CIP_JSON_FreeObject(JSONSQLObj);
end;