Click or drag to resize
CalculationWorks Logo
Tables

Create tables and columns. Add functions and validators.

TABLES

This section contains the following subsections:

Category Tables Table

TABLES Commands

Image

Command

Description

Bcf Add

Add Table

Adds an entry to the TABLES table.

Bcf Delete 12

Delete Table

Deletes selected rows from TABLES table.

Show GridlinesHS

Toggle Columns

Toggles column filter.

comment 16xMD

Edit Summary

Opens the summary editor.

TABLES Table

Name

Description

(blank)

Row index.

Name

Table name.

Summary (hidden by default)

Not used.

Data Member Order (hidden by default)

Specifies poco fields DataMemberAttribute.Order property.

Omit Table Typing (hidden by default)

Checking suppresses table code generation in the typed dataset class. Untyped access will be granted.

Omit View (hidden by default)

Checking suppresses the view code generation in the viewmanager class.

Omit Poco (hidden by default)

Checking suppresses POCO code generation for the table.

Table Class Name (hidden by default)

Typed table class name.

Row Class Name (hidden by default)

Typed row class name.

TableView Class Name (hidden by default)

Typed tableview class name.

RowView Class Name (hidden by default)

Typed rowview class name.

Table Property Name (hidden by default)

Typed datasets property name for the table.

TableView Property Name (hidden by default)

Typed viewmanagers property name for the tableview.

TABLE Properties

Name

Description

Name

Table name.

Omit Table Typing

Checking suppresses table code generation in the typed dataset class. Untyped access will be granted.

Table Class Name

Typed table class name.

Table Class Name Auto

When checked "Table Class Name" is inferred from "Table Class Name Format" (see Project/DataSet) and table name.

Table Property Name

Typed datasets property name for the table.

Table Property Name Auto

When checked "Table Property Name" is inferred from "Table Property Name Format" (see Project/DataSet) and table name.

Table Property Modifier

Modifier of typed datasets property name for the table.

Row Class Name

Typed row class name.

Row Class Name Auto

When checked "Row Class Name" is inferred from "Row Class Name Format" (see Project/DataSet) and table name.

Omit View

Checking suppresses the view code generation in the viewmanager class.

TableView Class Name

Typed tableview class name.

TableView Class Name Auto

When checked "TableView Class Name" is inferred from "TableView Class Name Format" (see Project/AllViews) and table name.

TableView Property Name

Typed viewmanagers property name for the tableview.

TableView Property Name Auto

When checked "TableView Property Name" is inferred from "TableView Property Name Format" (see Project/AllViews) and table name.

RowView Class Name

Typed rowview class name.

RowView Class Name Auto

When checked "RowView Class Name" is inferred from "RowView Class Name Format" (see Project/AllViews) and table name.

Omit Poco (hidden by default)

Checking suppresses POCO code generation for the table.

COLUMNS

This section contains the following subsections:

Category Tables Columns

COLUMNS Commands

Image

Command

Description

Bcf Add

Add Column

Adds an entry to the COLUMNS table.

Bcf Delete 12

Delete Column

Deletes selected rows from COLUMNS table.

Filter Alphabetically 5567 32

Filter Columns

Shows/enables the column name filter.

Browse Data Type

Find Data Type

Opens the Data Type Browser Dialog.

Browse Function

Find Function Type

Opens the Function Type Browser Dialog.

Dependancy 12861

Browse Dependencies

Opens the Column Dependencies Browser Dialog.

Show GridlinesHS

Toggle Columns

Toggles column filter.

comment 16xMD

Edit Summary

Opens the summary editor.

COLUMNS Table

Name

Description

(blank)

Row index.

Name

Column Name.

Type

Property type name.

You may omit namespace when namespace is mentioned in References/NAMESPACES.

Allow Null (hidden by default)

Determines whether column will accept null value.

Unchecking will add a not-null-contraint to the column behaviors.

Summary (hidden by default)

Not used.

Default (hidden by default)

Determines a default value.

Specifing a default value will add a BcfColumnDefaultValueSourceT to the columns behavior.

Function (hidden by default)

Functions type name.

You may omit namespace when namespace is mentioned in References/NAMESPACES.

Primary Key (hidden by default)

Determines if column is (a part of) the tables primary key.

Omit Row Property (hidden by default)

Checking suppresses the property generation in the typed row class.

Omit RowView Property (hidden by default)

Checking suppresses the property generation in the typed RowView class.

Omit Poco Field (hidden by default)

Checking suppresses the field generation for the column in the poco class.

Data Member Order (hidden by default)

Specifies poco fields DataMemberAttribute.Order property.

Read Only (hidden by default)

Determines if column is read only.

Parallel (hidden by default)

If not checked function will not be executed parallel.

COLUMN Properties

Name

Description

Name

Column Name.

Type

Property type name.

You may omit namespace when namespace is mentioned in References/NAMESPACES.

Type (C#)

Property type c# code.

Always read only.

Default

Determines a default value.

Specifing a default value will add a BcfColumnDefaultValueSourceT to the columns behavior.

Function

Functions type name.

You may omit namespace when namespace is mentioned in References/NAMESPACES.

Function (C#)

Functions type c# code.

Always read only.

Column Property Name

Typed table property name for the column.

Primary Key

Determines if column is (a part of) the tables primary key.

Allow Null

Determines whether column will accept null value.

Unchecking will add a not-null-contraint to the column behaviors.

Read Only

Determines if column is read only.

Omit Poco Field

Checking suppresses the field generation for the column in the poco class.

Omit Row Property

Checking suppresses the property generation in the typed row class.

Omit RowView Property

Checking suppresses the property generation in the typed RowView class.

Allow Compute Parallel

If not checked function will not be executed parallel.

Column Property Name Auto

When checked "Column Property Name" is inferred from "Column Property Name Format" (see Project/DataSet) and column name.

PARAMETERS

This section contains the following subsections:

Category Tables Column Parameters

PARAMETERS Commands

Image

Command

Description

Bcf Add

Add Parameters

  • Add All - Adds an entry to PARAMETERS Table for each missing function parameters.

  • Add Mandatory - Adds an entry to PARAMETERS Table for each missing mandatory function parameters.

  • Add Empty - Adds an entry to PARAMETERS Table.

  • [NAME] - Adds an entry with [NAME] to PARAMETERS Table.

Bcf Delete 12

Delete Parameters

Deletes selected rows from PARAMETERS Table.

Link

Link Parameter

Opens Access Path Browser Dialog.

CopyHS

Generate Code

Generate code and set to clipboard.

  • Function Difference - If function class name was not recognized a function template code will be copied, else property code of unrecognized parameters will be copied to clipboard.

  • Optional Parameter(s) - Creates code for selected parameters and decorates properties with BcfPropertyAttribute.

  • Mandatory Parameter(s) - Creates code for selected parameters and decorates properties with BcfMandatoryAttribute.

Show GridlinesHS

Toggle Columns

Toggles column filter.

PARAMETERS Table

Name

Description

(blank)

Row index.

Name

Parameter name.

Mandatory

Indicates whether parameter assignment is mandatory (parameter property is decorated with BcfMandatoryAttribute) or not.

Always read only.

Access Path (hidden by default)

Parameter dynamic assignment.

Parameter assignment always ends with a column name. Parameter assignment may start with Relation-Steps. When BCF collects parameter input it starts with current row; follows rows along the Relation-Steps (prefix "+" means "ToChild" and "-" "ToParent"; suffix "%" means distinct rows and "*" all rows) and fianlly takes value from column mentioned at parameter assignment end. If any relation step is "ToChild" a value array will be taken. See also Access Path Browser Dialog.

Value (hidden by default)

Parameter static assignment

Constant expression to use as parameter value.

Summary (hidden by default)

Not used.

Value Type (hidden by default)

Editor evaluated type depending on "Access Path" and source column type.

Source Type (hidden by default)

Parameter property type in function class.

Always read only.

PARAMETER Properties

Name

Description

Name

Parameter name.

Parameter Type

Parameter property type in function class.

Always read only.

Value

Parameter static assignment

Constant expression to use as parameter value.

Access Path

Parameter dynamic assignment.

Parameter assignment always ends with a column name. Parameter assignment may start with Relation-Steps. When BCF collects parameter input it starts with current row; follows distinct rows along the Relation-Steps (prefix "+" means "ToChild"; "-" "ToParent") and fianlly takes value from column mentioned at parameter assignment end. If any relation step is "ToChild" a value array will be taken. See also Access Path Browser Dialog.

Source Type

Editor evaluated type depending on "Access Path" and source column type.

Always read only.

Suppress "Potential Circular Reference" Warning

Suppresses "Parameter Column Association with potential circular reference" warning.

Warning may occur when using parameter access via self joins.

The similar error "Parameter Column Association with unavoidable circular reference" can not be suppressed.

VALIDATORS

This section contains the following subsections:

Category Tables Validators

VALIDATORS Commands

Image

Command

Description

Bcf Add

Add Validator

Adds an entry to the VALIDATORS Table and opens the Validator Type Browser Dialog.

Browse Rule

Add Validator

Opens the Validator Type Browser Dialog.

Dependancy 12861

Browse Dependencies

Opens the Column Dependencies Browser Dialog.

Bcf Delete 12

Delete Validator

Deletes selected rows from VALIDATORS table.

Show GridlinesHS

Toggle Columns

Toggles column filter.

comment 16xMD

Edit Summary

Opens the summary editor.

VALIDATORS Table

Name

Description

(blank)

Row index.

Validator Type

Validators type name.

You may omit namespace when namespace is mentioned in References/NAMESPACES.

Tagging

A ";"-separated list of parameters to tag.

Always read only.

Summary (hidden by default)

Not used.

Parallel (hidden by default)

If not checked validator will not be executed parallel.

VALIDATOR Properties

Name

Description

Validator

Validators type name.

You may omit namespace when namespace is mentioned in References/NAMESPACES.

Validator (C#)

Validator type c# code.

Always read only.

Tagging

A ";"-separated list of parameters to tag.

Always read only.

Allow Compute Parallel

If not checked validator will not be executed parallel.

VALIDATOR PARAMETERS

This section contains the following subsections:

Category Tables Validator Parameters

VALIDATOR PARAMETERS Commands

Image

Command

Description

Bcf Add

Add Parameters

  • Add All - Adds an entry to VALIDATOR PARAMETERS Table for each missing validator parameters.

  • Add Mandatory - Adds an entry to VALIDATOR PARAMETERS Table for each missing mandatory validator parameters.

  • Add Empty - Adds an entry to VALIDATOR PARAMETERS Table.

  • [NAME] - Adds an entry with [NAME] to VALIDATOR PARAMETERS Table.

Bcf Delete 12

Delete Parameters

Deletes selected rows from VALIDATOR PARAMETERS Table.

Link

Link Parameter

Opens Parameter Access Path Dialog.

CopyHS

Generate Code

Generate code and set to clipboard.

  • Validator Difference - If validator class name was not recognized a validator template code will be copied, else property code of unrecognized parameters will be copied to clipboard.

  • Optional Parameter(s) - Creates code for selected parameters and decorates properties with BcfPropertyAttribute.

  • Mandatory Parameter(s) - Creates code for selected parameters and decorates properties with BcfMandatoryAttribute.

Show GridlinesHS

Toggle Columns

Toggles column filter.

VALIDATOR PARAMETERS Table

Name

Description

(blank)

Row index.

Name

Parameter name.

Tag Cell(s)

Determines whether parameter source cells will be tagged with the validator message or not.

Mandatory

Indicates whether parameter assignment is mandatory (parameter property is decorated with BcfMandatoryAttribute) or not.

Always read only.

Access Path (hidden by default)

Parameter dynamic assignment.

Parameter assignment always ends with a column name. Parameter assignment may start with Relation-Steps. When BCF collects parameter input it starts with current row; follows distinct rows along the Relation-Steps (prefix "+" means "ToChild"; "-" "ToParent") and fianlly takes value from column mentioned at parameter assignment end. If any relation step is "ToChild" a value array will be taken. See also Access Path Browser Dialog.

Value (hidden by default)

Parameter static assignment

Constant expression to use as parameter value.

Summary (hidden by default)

Not used.

Value Type (hidden by default)

Editor evaluated type depending on "Access Path" and source column type.

Always read only.

Source Type (hidden by default)

Parameter property type in function class.

Always read only.

VALIDATOR PARAMETER Properties

Name

Description

Name

Parameter name.

Parameter Type

Parameter property type in validator class.

Always read only.

Value

Parameter static assignment

Constant expression to use as parameter value.

Access Path

Parameter dynamic assignment.

Parameter assignment always ends with a column name. Parameter assignment may start with Relation-Steps. When BCF collects parameter input it starts with current row; follows distinct rows along the Relation-Steps (prefix "+" means "ToChild"; "-" "ToParent") and fianlly takes value from column mentioned at parameter assignment end. If any relation step is "ToChild" a value array will be taken. See also Access Path Browser Dialog.

Source Type

Editor evaluated type depending on "Access Path" and source column type.

Always read only.