Column Properties

Developers can utilize the xls.handlers table to adjust column properties.

Additionally, the xls.columns table allows developers to define columns for REST API objects.

DataType Properties

SaveToDB products leverage column properties in connection wizards, SELECT commands, and when saving changes.

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

OData metadata offers comprehensive column descriptions for most entity types.

However, the following objects may lack sufficient column information:

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

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

Use the DataType<Type> value to specify the 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:

DoNotChange
DoNotSave
DoNotSelect
DoNotSort
DoNotTranslate
DoNotChange: Prevents manual changes to the column.
DoNotSave: Excludes columns from the INSERT and UPDATE statements used for saving changes.
DoNotSelect: Prevents the column from being selected in connection wizards. Note that users can still manually edit the query in Microsoft Excel.
DoNotSort: Disables sorting for columns or entire tables in DBEdit, DBGate, and ODataDB. SaveToDB does not disable sorting in Microsoft Excel.
DoNotTranslate: Prevents translation of column headers or entire tables.

You can use the following formula-related properties:

For more details, see the Converting Formulas topic.

To convert text hyperlinks into hyperlink objects, use the following type:

For more information, refer to the Converting Hyperlinks topic.