IDatabaseColumnValue

class IDatabaseColumnValue

Bases: ImpactCOMWrapperBase

Summary:

Allows you to retrieve values for each column returned in a query result set.

Remarks:

You can retrieve the IDatabaseColumnValue object(s) immediately after a query is opened. As each row is iterated the value returned from IDatabaseColumnValue.value will be for the current record. You do not need to retrieve a new IDatabaseColumnValue each time the query moves to the next row, and in fact doing so can affect performance. Introduced In Impact 11.0.0.35.

Wraps a COM object or another wrapper instance. Accepts: - A valid impact_object - An existing impact_com_wrapper_base-derived instance

property bytes_as_variant

Gets bytes_as_variant.

Summary:

Determines if binary data from BLOB columns is returned as a variant array of bytes or a variant array of variants.

Returns:

The value of bytes_as_variant.

Return type:

bytes_as_variant (bool)

Examples:

property is_null

Gets is_null.

Summary:

Determines if the column value for the current record is null.

Returns:

The value of is_null.

Return type:

is_null (bool)

property name

Gets Name.

Summary:

Returns the name of the column.

Returns:

The value of Name.

Return type:

name (str)

property type

Gets Type.

Summary:

Determines the data type of the column.

Returns:

The value of Type.

Return type:

type (ipDatabaseColumnType)

property value

Gets Value.

Summary:

Returns the value of the column as a native variant type for the current record.

Remarks:

The values returned are native types such as Integer, String, Boolean, Float to match the underlying storage type.

Returns:

The value of Value.

Return type:

value (any)

isNone()

Checks if the COM object is None. This is useful for determining if the wrapper has been initialized with a valid COM object.