WEBcnx 2023.1 is out now bringing with it a host of new features and performance enhancements. Read more.

Open navigation

Database Field

Use this form to add or modify database fields. It is accessed from places such as the Browser Options form, the Database Queries - Display Fields form or the Project Browser Advanced Find - Display Fields form.

Database - New or Edit Field

When configuring a database field to be displayed in the Project Browser, you should specify:

Database Field

Name

Enter a descriptive name.

Field

Choose the table and field.

You can add advanced query display columns and/or table relationship columns directly to the field list in the browser. This works when configuring Projects and Working Projects fields in the Browser, Locate Projects fields in the Open Projects form, and Layers fields in the Project Properties form.

You can add a lookup column from the CUSTOMER or DRAWINGS table (such as DRAWINGS.D_PSTATUS) and if an advanced query display column is configured this will be shown instead of the foreign key value.

When adding a new field the Field combo includes all defined table relationships as appropriate, so you can also add any column from the parent table of a table relationship.

For Projects, Working Projects and Locate Projects fields you can use any lookup for CUSTOMERS or DRAWINGS. For Layers you can add any lookup for LAYERS.

So for example you can use:-

Table Relationship:Display Column To Show
 DRAWINGS.D_PSTATUS -> PROJSTAT.PS_KEY:PS_NAME A project status
 DRAWINGS.D_SALEREP -> SALESREP.SR_KEY:SR_FULLNAME A sales person
 CUSTOMER.CS_PRIADDR -> ADDRESS.A_KEY:A_STREET1 A customers primary address street name
 CUSTOMER.CS_PRIADDR -> ADDRESS.A_KEY:A_CITY A customers primary address city
 CUSTOMER.CS_CUSTGRP -> CUSTOMER.CS_KEY:CS_NAME A customer group name

 

You can add multiple columns from the same lookup table (CS_PRIADDR in the above example) if required.

Data Format

Depending on the field type chosen, you may be able to configure the display format:-

Display Options

Header Align

From the drop-down list choose either Left, Right or Centre.

Data Align

From the drop-down list choose either Left, Right or Centre.

Custom Drawing

Switch this option on if you want to customise the text for this field.

Background

This is the colour used for this field's background.  Click on the displayed colour to open the standard colour selection form, from where you can either choose a pre-defined colour or define your own.

Font

From the drop-down list choose the required text font.

Colour

This is the colour used to display the text in this field.  Click on the displayed colour to open the standard colour selection form, from where you can either choose a pre-defined colour or define your own.

Bold

Switch this option on if required.

Italic

Switch this option on if required.

Related topics: Database Administration


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

You may like to read -