Update Block Data

This command fills out attribute values in drawing blocks using data from database tables. The links between the block attributes and the database fields are defined in the Define Block Database Links command.

The program starts by prompting you to select the block entities to process. Then a dialog is displayed with a list of the block names from the selected entities that also have database links defined. Highlight the block name to process from the list. Then the program lists the attributes for the block. Highlight the attribute that corresponds to the key field from the database table. Then choose the Insert/Update button to update the drawing block attributes.

Under Source for Key Values, the Drawing Attributes option will update each block by reading the value of the key attribute and then looking up the database record with the matching value. The other block attributes and then filled out using the values from this database record. The Select from Database option allows you to choose a database record by highlighting the value from the key field. All the block entities will be filled out using the values from this selected database record.

The Preview Links option will bring up a dialog with a spreadsheet view of the data values from the database for each block. You can edit the values, update the block or skip updating the current block.

Example point blocks updated from CITIES database table

Pulldown Menu Location: GIS Data
Keyboard Command: update_blk
Prerequisite:
Blocks, database table and link definition