VTable Class: Special Fields Creation

Declaration:

CreateArrayField(
	inName as String, 
        inItemType as EVFieldType,
        inDimSize as Integer
	inFlags as EVFlag = fNone ) as VVariant

Parameters:

• inName - The name of the field.
• inItemType - The type of array items.
• inDimSize - The maximal number of items (size of array).
• inFlags - The flags of the field.

Description:

Creates a fixed size VArray field.

Example:

fldSalary12 = tblPerson.CreateArrayField( "fldSalary", EVFieldType.ULong, 12 )

Declaration:

CreateVariantField(
	inName as String, 
	inFlags as EVFlag = fNone ) as VVariant

Parameters:

• inName - The name of the field.
• inFlags - The flags of the field.

Description:

Creates an VVariant field.

For VARIANT field can be used EVFlag.fCompressed flag, like for BLOB. In this case, VARIANT field will compress big values. These are values that go into segment file, i.e. have original size > kPageSize (4Rb on default). Notice that picture values are not compressed because they already have a compressed picture format.

Example:

fldAge = tblPerson.CreateVariantField( "fldValue",  EVFlags.fNullable )