EMS logo

EMS SQL Manager for InterBase/Firebird

On-line Documentation

Setting field defaults


The Default tab allows you to define the default value for the column. You can either select the default object from the database defaults or define the default value for the column.

 

Specify a default field value that is entered when no other entry is made.

Possible values are:

  • literal: Inserts a specified string, numeric value, or date value;
  • NULL: Enters a NULL value;
  • USER: Enters the user name of the current user.

 

hs1770_Setting field defaults

 

Note that the default value set for the field based on a domain at the Default tab of the Field Editor will override the corresponding value set for the domain.

 

 

Enabling the chbox Not Null option of the Field Editor involves that Field Value by Default dialog appears. You will be able to set a direct value as default or use the one of the listed fields.

 

hs1770_Setting field defaults2

 

 

See also:

Field Editor

 

 

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Gold Certified Partner
Oracle Certified Partner
Borland Technology Partner
CodeGear - Where Developers Matter