Documentation | Help File | UI | 2D Mode | Menu | Data | Join Database
Clicking on the Data/Join Database
menu item allows to temporarily attach a database table to the attribute table of a vector layer. The Editor sets up a persistent linkage to a database, without importing the table into the layer. When the connection has established the columns from the database are displayed in the Data panel along with the layer attributes. The attributes stored in the database are easily distinguishable by the db. prefix in the column names. The database columns cannot be edited from the Editor, but they are dynamically updated whenever the values are changed within the database.
To attach a database table to the attribute table of a vector layer
Data/Join Database
menu item - this invokes the Join Database
dialog box.Join Database
dialog box, enter the connection string in the Connection string
field or click on the Build…
button to use an automated method. Clicking on the Build…
button invokes the Connection string
dialog box. If a file with connection parameters is available check the Use data link file
option, click on the Browse…
button and point to the file. Otherwise check the Use connection string
option, click on the Build…
button and use the Data link properties
dialog box define the connection according to the configuration of your database. Finally, click on the OK
button to close the Connection string
dialog box.Join Database
dialog box is filled with information about available database tables.Table
list - this table will be attached to the attribute table.Order by
list - this column will be used to sort the records of the table.SQL query
field.Preview
button - this causes refresh of the Data preview
field which presents the database content selected by the SQL query.Assign by
box use the Layer attribute
and the Database column
lists to define how the records from the database should be assigned to the shapes.Join
button - the selected database content will be attached to the attribute table of the layer.
« Previous
button.