Description

This type represents a keyValue used by some database operations where the user is required to provide a unique primary key.

        In this simple shortcu example the target has a single column priamry key, the column name is deduced from the table schema

        XML Form
        <keyValue>
          1234
        </keyValue>

        JSON Form
        "keyValue", 1234
        
        In this example the target has a single column priamry key, this time the column is targeted directly. The column must be
        defined the the schema as the tables primary key
        
        XML Form            
        <keyValue>
          <h_id>1234</h_id>
        </keyValue>

        JSON Form
        "keyValue": {
            "h_id": 1234
        }

        In this example the target table requires a composite key made up of two column values

        XML Form
        <keyValue>
          &lt;h_id&gt;smith&lt;/h_id&gt;
          &lt;h_postcode&gt;NW10&lt;/h_postcode&gt;
        </keyValue>
        
        JSON Form
        "keyValue": {
            "h_id": "smith",
            "h_postcode": "NW10"
        }

Properties

This complex type contains no defined properties.