EMS logo

Products Navigation

Data Import for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Import for InterBase/Firebird

On-line Documentation

Add/Edit field


When you import data with destination table creation, you can manage this table's fields.

 

Use the context menu to Add/Edit/Drop a field.

 

menuEditField

 

Selecting Add field or Edit field context menu item opens the field editor that allows you to view/edit the properties of the destination table fields.

 

 

Field Editor

 

Use the Column edit box to set the field name. Note that the name of the field must be unique among all the field names in the table.

 

The Type tab defines the type of the field data.

 

Size

Defines the size of the field value.

 

Scale

For numeric and decimal types you need to define the number of decimal to the right of the decimal point.

 

Default value

Define this option value if you need inserted records to get specified value.

 

Define character set and collation at the appropriate fields.

 

CheckBox Not NULL

Check this option to prevent the entry of NULL or unknown values in column.