Page tree
Skip to end of metadata
Go to start of metadata

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. Only included columns get updated.


Arguments


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.


Remarks


Examples

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


See Also