<ST_GrowShrinkType> (Grow Shrink Type)

This type enumerates behavior patterns for refreshing external data in a query table.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

<insertClear> (Insert & Clear On Refresh)

Insert entire rows for new data, clear unused cells.

<insertDelete> (Insert & Delete On Refresh)

Insert cells for new data, delete unused cells.

<overwriteClear> (Overwrite & Clear On Refresh)

Overwrite existing cells with new data, clear unused cells.

Referenced By

<queryTable@growShrinkType> (§3.12.2)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_GrowShrinkType">
	<restriction base="xsd:string">
	<enumeration value="insertDelete"/>
	<enumeration value="insertClear"/>
	<enumeration value="overwriteClear"/>
	</restriction>
</simpleType>