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.

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';

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';

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';

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';

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';

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';

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';

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';

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';

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';

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

GET PROPERTY Encrypted of Field t1.f1;

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;

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

GET PROPERTY StructureEncrypted of Field t1.f1;

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

GET PROPERTY Compressed of Field t1.f1;

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

GET PROPERTY ID of Field t1.f1;

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

GET PROPERTY IndexByWords of Field t1.f1;

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

GET PROPERTY Indexed of Field t1.f1;

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

GET PROPERTY Identity of Field t1.f1;

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

GET PROPERTY LinkName of Field t1.f1;

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

GET PROPERTY MethodText of Field t1.f1;

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;

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;

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

GET PROPERTY PropertyCount of Field t1.f1;

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

GET PROPERTY SegmentSize of Field t1.f1;

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

GET PROPERTY Size of Field t1.f1;

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

GET PROPERTY Type of Field t1.f1;

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;