OB SET

Home

4D v15.4

OB SET


OB SET ( object ; property ; value {; property2 ; value2 ; ... ; propertyN ; valueN} )

Parameter	Type	Description
object	Object, Object Field	Structured object
property	Text	Name of property to set
value	Text, Date, Boolean, Pointer, Number, Object	New value of property

Description

The OB SET command creates or modifies one or more property/value pairs in the language object designated by the object parameter.

object must have been defined using the C_OBJECT command or designate a 4D object field.

In the property parameter, pass the label of the property to be created or modified. If the property already exists in object, its value is updated. If it does not exist, it is created.
Note that the property parameter is case sensitive.

In the value parameter, pass the value you want to set for the property. Several data types are supported. Note that:

if you pass a pointer, it is kept as is; it is evaluated using the JSON Stringify command,
dates are stored in the format "YYYY-MM-DDTHH:mm:ss.SSSZ". When converting 4D dates into text prior to storing them in the object, by default the program takes the local time zone into account. You can modify this behavior using the JSON use local time selector of the SET DATABASE PARAMETER command.
if you pass a time, it is stored as a number of milliseconds (Real) in object.
if you pass a language object, the command uses the object reference and not a copy.

Example 1

Creating an object and adding a text type property:

 C_OBJECT($Object)

 OB SET($Object ;"FirstName";"John";"LastName";"Smith")

  // $Object = {"FirstName":"John","LastName":"Smith"}

Example 2

Creating an object and adding a Boolean type property:

 C_OBJECT($Object)

 OB SET($Object ;"LastName";"smith";"age";42;"client";True)

  // $Object = {"LastName":"smith","age":42,"client":true}

Example 3

Modifying a property:

  // $Object = {"FirstName":"John","LastName":"Smith"}

 OB SET($Object ;"FirstName";"Paul")

  // $Object = {"FirstName":"Paul","LastName":"Smith"}

Example 4

Adding a property:

  // $Object = {"FirstName":"John","LastName":"Smith"}

 OB SET($Object ;"department";"Accounting")

  // $Object = {"FirstName":"Paul","LastName":"Smith","department":"Accounting"}

Example 5

Renaming a property:

 C_OBJECT($Object)

 OB SET($Object ;"LastName";"James";"age";35)

  // $Object = {"LastName":"James","age":35}

 OB SET($Object ;"FirstName";OB Get($Object ;"LastName"))

  // $Object = {"FirstName":""James","nom":"James","age":35}

 OB REMOVE($Object ;"LastName")

  // $Object = {"FirstName":""James","age":35}

Example 6

Using a pointer:

  // $Object = {"FirstName":"Paul","LastName":"Smith"}

 C_TEXT($LastName)

 OB SET($Object ;"LastName";->$LastName)

  // $Object = {"FirstName":"Paul","LastName":"->$LastName"}

 $JsonString:=JSON Stringify($Object)

  // $JsonString="{"FirstName":"Paul","LastName":""}

 $LastName:="Wesson"

 $JsonString:=JSON Stringify($Object)

  // $JsonString="{"FirstName":"Paul","LastName":"Wesson"}

Example 7

Using an object:

 C_OBJECT($ref_smith)

 OB SET($ref_smith ;"name";"Smith")

 C_OBJECT($ref_emp)

 OB SET($ref_emp ;"employee";$ref_smith)

 $Json_string :=JSON Stringify($ref_emp)

  // $ref_emp = {"employee":{"name":"Smith"}} (object)

  // $Json_string = "{"employee":{"name":"Smith"}}" (string)

You can also change a value on the fly:

 OB SET($ref_smith ;"name";"Smyth")

  // $ref_smith = {"employee":{"name":"Smyth"}}

 $string:=JSON Stringify($ref_emp)

  // $string = "{"employee":{"name":"Smyth"}}"

Example 8

Using an object array:

 C_TEXT($jsonString)

 C_OBJECT($Contact)

 OB SET($Contact;"FirstName";"Alan")

 OB SET($Contact;"LastName";"Monroe")

 OB SET($Contact;"age";40)

 OB SET($Contact;"telephone";"[2128675309,2128671234]")

 

 $jsonString:=JSON Stringify($Contact)

 

  // Value of $Contact:

  // {"LastName":"Monroe","telephone":"[2128675309,2128671234]",

  // "age":40,"FirstName":"Alan"}

 

  // Value of $jsonString:

  // "{"LastName":"Monroe","telephone":"[2128675309,2128671234]",

  // "age":40,"FirstName":"Alan"}"

Example 9

If you have defined the [Rect]Desc field as an object field, you can write:

 CREATE RECORD([Rect])

 [Rect]Name:="Blue square"

 OB SET([Rect]Desc;"x";"50";"y";"50";"color";"blue")

 SAVE RECORD([Rect])

Example 10

You want to export data in JSON that contains a converted 4D date. Note that conversion occurs when the date is saved in the object, so you must call the SET DATABASE PARAMETER command before calling OB SET:

 C_OBJECT($o)

 SET DATABASE PARAMETER(JSON use local time;0)

 OB SET($o ;"myDate";Current date) // JSON conversion

 $json:=JSON Stringify($o)

 SET DATABASE PARAMETER(JSON use local time;1)