$Database.EnsureData

Overview¶

Object $Database.EnsureData ( [dataStore], schema, table, column, value, input, initInput )

Inserts or updates a row in table by specified column and value as single criteria.

String dataStore Name or Id number of target data store. This parameter is optional.

String dataStore Name or Id number of target data store. This parameter is optional.

String schema Name of target schema

String table Name of target table

String column Name of column to use as criteria

Object value Value of column to use as criteria

Object input Object or function for column values for updating.

Object inputInit Object or function for initialize for new rows. Optional.

$Database.EnsureData("MySchema", "MyTable", "Id", id, {
    Name : $Xml.Evaluate('Name')   
}, {   
    IsNew : true
});