Set Key button


Any entity should have a key. Key could be single field or multi field.

Single field key should have name "Id" and it cannot be changed (this doesn't concern database name (Data Mapping - Name), it could have any name).

In multi field case fields could have any names.


Changes in Database section would not be transfered to database. See Code Cruiser Development Cycle for details.


Entity Field properties


Section

Name

Description

Basic

Code Default

A piece of c#.NET code for field initialization on entity creation.

Basic

Format

Display format for a field. See Formats chapter for details. This option used as a default value in screen blocks.

Basic

Name

Name of a field. Should be machine friendly.

Basic

Type

Machine type. Selected type should be compatible with database type.

FileLink is a special type to indicate that this field represents an uploaded file. It is available for int database types.

Basic

Display Name

Display Name is automatically copied to any place it is used (Query field, Screens block fields) if its name value was not replaced by another value at that object.

This editing logic is very useful when a field display name is renamed.

Basic

File Storage

If FileLink type is selected as field type then File Storage could be selected for this field.


User Interface

Description

Useful to make notes about purpose of this Field.

Database

Data Mapping - Column

Table column name in database.

Database

Data Mapping - Type

Column type in database.

Database

Data Mapping - Nullable

If field is NULL in database.

Database

Data Mapping - SQL Type

Filed type in database.

Database

Data Mapping - Length

Type length.

Database

Data Mapping - Precision

Precision for numeric data types.

Database

Data Mapping - Scale

Scale for numeric data types.

Security

Read

Select a permission or built in option for security logic.

Built in options:

<private> means that this option available only on server side.

<auto> means permission would be auto created. You should run permission creation script on deployment to be able to see updated permissions. See Deployment chapter.

<parent> means that entity field Security.Read setting would be used.


If field is restricted by permissions then data would be replaced by null, 0 or empty string depending on type.

Security

Update

Select a permission or built in option for security logic.

Built in options:

<private> means that this option available only on server side.

<auto> means permission would be auto created. You should run permission creation script on deployment to be able to see updated permissions. See Deployment chapter.

<parent> means that entity field Security.Update setting would be used.


If field is restricted by permissions then data would be replaced by null, 0 or empty string depending on type.


Created with the Personal Edition of HelpNDoc: Full-featured Help generator