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


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.


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')    
}, {    
    CreateDate :

See Also