Switch to: V11V10V9V8V7V6V5

Data Editor - Variant Editor

You can view and change values of VARIANT fields in Valentina and MS SQL databases using the Data Editor.

To activate the Variant Editor, click the cell of a VARIANT field – the Variant Dialog popup opens. To open it in a modal form it is necessary to click Content Editor button below the grid.

You can change the Variant Type with the Variant selector and change the contents of the field within the edit area.

Variant Editor

Type select list is located at the top of the dialog. It contains a menu with possible types. For example, a list for Valenitna DB contains the following items:

Value Types

Depending on the type of value the editor has appropriate controls to edit it.

On the switch of the type, the default value is assigned.

String Value Variant Editor

This is a custom string editor to edit text contained in a Variant.

String Value

Boolean Value Variant Editor

This is a custom Boolean editor to edit a Boolean value contained in a Variant.

Boolean Value

Binary Value Variant Editor

This is a custom binary data editor to edit binary data contained in a Variant.

Binary Value

If the field contains data which is editable with specialized viewers/editors, in that case, an additional tab is shown:

Binary Value

Picture Value Variant Editor

This is a custom picture editor to display and edit Picture contained in a Variant.

Picture Value

Date And Time Values Variant Editor

These are custom editors for selecting options or entering numeric data for DATE or Time data stored in Variants.

Date Value

DateTime Value

Time Value

Numeric Values Variant Editor

This is a custom number editor to edit numerical data contained in a Variant.

Numeric Value