Switch to: V11V10V9V8V7V6V5

Valentina Field Properties

On this page you can see list of system Valentina Field properties. You can get the list of properties using SHOW PROPERTIES command.

Localizable properties

AlternateHandling

Read-write system property. Operate with UCOL_ALTERNATE_HANDLING object value.

GET PROPERTY AlternateHandling of Field t1.f1;
SET PROPERTY AlternateHandling of Field t1.f1 to 'kDefault';

CaseFirst

Read-write system property. Operate with UCOL_CASE_FIRST object value.

GET PROPERTY CaseFirst of Field t1.f1;
SET PROPERTY CaseFirst of Field t1.f1 to 'kDefault';

CaseLevel

Read-write system property. Operate with UCOL_CASE_LEVEL object value.

GET PROPERTY CaseLevel of Field t1.f1;
SET PROPERTY CaseLevel of Field t1.f1 to 'kDefault';

FrenchCollation

Read-write system property. Operate with UCOL_FRENCH_COLLATION object value.

GET PROPERTY FrenchCollation of Field t1.f1;
SET PROPERTY FrenchCollation of Field t1.f1 to 'kDefault';

HiraganaQuaternaryMode

Read-write system property. Operate with UCOL_HIRAGANA_QUATERNARY_MODE object value.

GET PROPERTY HiraganaQuaternaryMode of Field t1.f1;
SET PROPERTY HiraganaQuaternaryMode of Field t1.f1 to 'kDefault';

IOEncoding

Read-write system property. Operate with IO_Encoding object value. It is temporary property (not stored to the schema).

GET PROPERTY IOEncoding of Field t1.f1;
SET PROPERTY IOEncoding of Field t1.f1 to 'UTF-16';

LocaleName

Read-write system property. Operate with LocaleName object value.

GET PROPERTY LocaleName of Field t1.f1;
SET PROPERTY LocaleName of Field t1.f1 to 'en_US';

NormalizationMode

Read-write system property. Operate with UCOL_NORMALIZATION_MODE object value.

GET PROPERTY NormalizationMode of Field t1.f1;
SET PROPERTY NormalizationMode of Field t1.f1 to 'kDefault';

NumericCollation

Read-write system property. Operate with UCOL_NUMERIC_COLLATION object value.

GET PROPERTY NumericCollation of Field t1.f1;
SET PROPERTY NumericCollation of Field t1.f1 to 'kDefault';

Strength

Read-write system property. Operate with UCOL_STRENGTH object value.

GET PROPERTY Strength of Field t1.f1;
SET PROPERTY Strength of Field t1.f1 to 'kDefault';

Encryptable properties

Encrypted

Read-only system property. Return 1 if object is encrypted and 0 otherwise.

GET PROPERTY Encrypted of Field t1.f1;

RequiresEncryptionKey

Read-only system property. Return 1 if object is a root of encrypted objects tree and 0 otherwise.

GET PROPERTY RequiresEncryptionKey of Field t1.f1;

StructureEncrypted

Read-only system property. Return 1 if object is a structure-encrypted and 0 otherwise.

GET PROPERTY StructureEncrypted of Field t1.f1;

Field properties

Compressed

Read-only system property. Return 1 if BLOB field is compressed and 0 otherwise.

GET PROPERTY Compressed of Field t1.f1;

ID

Read-only system property. Return IF of the field.

GET PROPERTY ID of Field t1.f1;

IndexByWords

Read-only system property. Return 1 if field has IndexByWords flag.

GET PROPERTY IndexByWords of Field t1.f1;

Indexed

Read-only system property. Return 1 if field has Indexed flag.

GET PROPERTY Indexed of Field t1.f1;

Identity

Read-only system property. Return 1 if field has Identity flag.

GET PROPERTY Identity of Field t1.f1;

LinkName

Read-only system property. Return link name of ObjectPtr field.

GET PROPERTY LinkName of Field t1.f1;

MethodText

Read-only system property. Return method text of calculated field.

GET PROPERTY MethodText of Field t1.f1;

MaxLength

Read-write property. Returns the maximal length of a String/VarChar field.

GET PROPERTY MaxLength of Field t1.f1;
SET PROPERTY MaxLength of Field t1.f1 TO 25;

Nullable

Read-write system property. Return 1 if field has Nullable flag.

GET PROPERTY Nullable of Field t1.f1;
SET PROPERTY Nullable of Field t1.f1 TO FALSE;

PropertyCount

Read-only system property. Return properties count of the field.

GET PROPERTY PropertyCount of Field t1.f1;

SegmentSize

Read-only system property. Return segment size of the BLOB field.

GET PROPERTY SegmentSize of Field t1.f1;

Size

Read-only system property. Return size of the field in bytes.

GET PROPERTY Size of Field t1.f1;

Type

Read-only system property. Return type of the field.

GET PROPERTY Type of Field t1.f1;

Unique

Read-write system property. Return 1 if field has Unique flag.

GET PROPERTY Unique of Field t1.f1;
SET PROPERTY Unique of Field t1.f1 TO FALSE;