Add Fields - Add new fields to multiple tables
With this function you can create several new fields in multiple tables or themes at one step. The list
Field History on the left side of the dialog can be used to select previously added fields quickly. The list
New Fields on the right side contains new fields that shall be added to the tables. The field properties (name, type, width, accuracy and initial value) and options of the function can be defined in the middle of the dialog.
pressed to select multiple tables or themes).
Field History: All the fields you have created in this project up to now are listed here.
Double-click on a field to add it to the New Fields directly or select a field and modify it's properties before you add it.
Clear: With this button you can remove the selected field from the field history (confirm with ) or clear the whole list (confirm with ).
New Fields: These fields will be created in the corresponding order (i.e. the top one first) in the active tables, as soon as you start the function by clicking on .
Add (hotkey Alt+A): Adds a new field with the current properties to the end of the list (only possible if the field name is specified and there is no other field of the same name in the list).
Update (hotkey Alt+U): Updates the properties of the active field (only possible if they have been altered). If you select another field without clicking on before, you will be asked if you want to update the previously modified field (), skip the changes () or continue to edit the field ().
Remove (hotkey Alt+R): Deletes the active field from the list (confirm with ).
Load (hotkey Alt+L): Load field definitions from a table file (replace existing new fields with ).
Move Up : Moves the active field one row up.
Move Down : Moves the active field one row down.
- You must activate the tables or themes, in which you want to add new fields, before calling the function (click on them with the mouse pointer - keep the
Hint: If you want to add a field that is similar to an already existing one, select it in Field History or New Fields, change the field name or other settings and click on Add. If you want to create a completely new field, just enter the field name and other settings and click on Add. The log of the added fields will get lost if you uninstall the extension Arc4You Data.
Name: The name of the new field. The maximum length of field names is 10 characters in dBASE and 16 characters in INFO tables. Longer field names will be truncated in the table file and the full name will only be used as an internal alias in the project.
Field Type: Number, String, Boolean (true or false) or Date.
Field Width: Field width of numeric or text fields. If you click on the small arrows and keep the Shift key pressed, the width will be changed in steps of 5 characters.
Decimal Places: Number of decimal places (decimal accuracy).
Note: The decimal point itself consumes one place of the field width, i.e. the number of possible pre-decimal places results from the total field width minus the number of decimal places minus 1.
Initial Value: You can define an optional value that initializes the field (this value will be stored in all records of the table). For text fields you must put the text in quotation marks (e.g. "Tom Miller"). For numeric fields you can as well use any valid calculation expression or Avenue function (e.g. 100/3, (134+985-97)^2, Number.GetPi).
Replace Existing Fields: Activate this option if you want to replace existing fields (same field name). Thus it is ensured, that the fields will get the desired field type and field width and all field values will be deleted - existing data will be irrecoverably lost. If this option is deactivated the existing fields and field values will be kept unchanged - no data will get lost. But if the field has any other field type or width, it may cause errors.
Initialize Existing Fields: Activate this option if you want to initialize the field values of existing fields (same field name) with the initial value. Thus it is ensured, that all old field values will be deleted. Width and accuracy of these fields will stay untouched. If this option is deactivated the existing field values will be kept unchanged - no data will get lost.
Clear Numeric Fields: Activate this option if the new numeric fields shall be empty (i.e. initialized with the Null value). If this option is deactivated all numeric fields will be initialized with 0 by default.
Hint: To clear particular numeric fields, enter NIL or Null as Initial Value.
After clicking on the New Fields will be created in the tables and recorded in the Field History of the project. The status bar shows the number of new fields and how many fields were replaced or kept. Existing fields with a different field type or a smaller field width are reported as errors.
© 2003 WLM Klosterhuber & Partner OEG