Design SuiteMultiple object connection

Command

Path

Object Connection

Tools > Database

When there are multiple similar objects that should be identically connected to database tables through attached record formats, it would be tedious to connect each one. The connection for multiple objects can be made at one time.

To connect a database to multiple objects:

Select several objects of the same type.

Select the command. Alternatively, click Object Database Connection from the Data tab of the Object Info palette.

The Multiple Objects Database Connection dialog box opens. By selecting a format field and selecting search filter criteria, the table rows associated can be searched.

ObjectMultiple.png 

Click to show/hide the parameters.Click to show/hide the parameters.

Parameter

Description

Available Records

Lists the record formats available for the selected objects (only record formats that are common to the selected objects display)

Database Connection

Opens the Record Formats Database Connection dialog box, to connect a record format to a database table

Add New Database Table Rows

Inserts a new row in the database table for each selected object, and associates each row with each object

Find Row by Value (exclude objects with existing object connection)

Only the format fields connected to a database are listed. Selects a format field, and uses the value from the selected objects that are not already connected to a database, to search the database table for a particular row. (Once the row is found, the Key identifier is used to link the table row to the record fields.)

Find Row by Value (for all objects)

Only the format fields connected to a database are listed. Selects a format field, and uses the value from the selected objects to search the database table for a particular row. (Once the row is found, the Key identifier is used to link the table row to the record fields.)

Show Database Table

Opens the Database Table dialog box, to view the database table associated with the record format and help determine which column to use for the search criteria

When this dialog is dismissed

Determines the selection status of resolved objects, or of unresolved objects that may require further attention to connect them. Select do not change selection to make no change to the number of selected objects.

Select a Format Field, and then click in the Find by Value column to select the field as a search filter.

On the right, the status of resolved objects indicates how many of the selected objects had data found in the database tables based on this search. When objects are resolved, their record field data is properly connected to the database table.

For each resolved object, the record fields are populated from the database table for the record instance attached to the objects.

Resolved objects are connected to the corresponding rows using the Key identifier, and then each row is associated with the corresponding object.

Single object connection

Editing object connections

Removing object connections

Database setup

Database connection

Record format database connection

Specifying update settings

Concept: Records, reports, and schedules

Database-Vectorworks communication

 

Was this page helpful?