Column Properties

Developers can use the xls.handlers table to tune column properties.

Developers can also use the xls.columns table to define columns of REST API objects.

DataType Properties

SaveToDB products use column properties in the connection wizards, SELECT commands, saving changes, etc.

The database metadata contains complete column descriptions for tables and views only.

OData metadata contains complete column descriptions for most entity types.

The following objects can have not enough information about columns:

You can define column data types using the following values in the EVENT_TYPE field:

Use BitColumn to format integer-type columns as check-boxes with three possible values: 0, 1, and NULL.

Use DataType<Type> value to define data types of columns or parameters.

For example:

ID	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	EVENT_NAME	HANDLER_SCHEMA	HANDLER_NAME	HANDLER_TYPE	HANDLER_CODE
	s02	code_cashbook	item_id	DataTypeInt			ATTRIBUTE

You can use the following event types to disable unwanted features:

Use DoNotChange to prevent manual column changes.

Use DoNotSave to exclude columns from the INSERT and UPDATE statements used to save changes.

Use DoNotSelect to prevent selecting the column in the connection wizards. Note that users can edit the query in Microsoft Excel manually.

Use DoNotSort to prevent sorting columns or entire tables in DBEdit, DBGate, and ODataDB. SaveToDB does not disable sorting in Microsoft Excel.

Use DoNotTranslate to prevent translating column headers or entire tables.

You can use the following formula-related properties:

See details in the Converting Formulas topic.

You can use the following type to convert text hyperlinks to hyperlink objects:

See details in the Converting Hyperlinks topic.