AddTables Class

Opens, joins  and adds table(s) to a workspace.

 

Constructor

AddTables(array options)

 

Initializes a new instance of the class with default settings.

 

Option Name	Type	Contents
TableName	string	Name of the table to add to the workspace
TableNames	array	Options array of left and right table as described in the table below
Filter	string	Selection set filter
LayerType	string	Optional. If using a line geographic file use "Node" to work with the endpoint layer or "Line" to work with the line layer
DesiredViewName	string	Optional. Name of the desired view name
OpenOpts	array	Open flags. Default is null. Read Only, AttributeTablesWritable, Shared

Note

        The views opened by the object, and the joined view are automatically closed when the object is out of scope.   See example below.

Table Names Option Array

Option Name	Type	Contents
Name	string	Table File Name
Field	string	Name of the join field

Properties

Name		Type	Contents
TableView		string	Get the name of the table view added to the workspace

 

Methods

 

JoinTables( sz)

Join the tables and return the name of the joined view.

 

Option		Type	Description
sz		string	Name of the desired view

 

GetViewNames( )

Returns an array of options with the name of the views.

 

Return Option	Type	Description
ViewName	string	Name of the table view

 

For joined view it returns:

 

Return Option for Joined Views	Type	Description
LeftView	string	Name of the left table
RightView	string	Name of the right table
JoinView	string	Name of the join view

 

Example

 

folder = RunMacro("G30 Tutorial Folder")

left_table = {Name: folder + "Parcels.BIN", "Field": "SBL"}

right_table = {Name: folder + "ParcelInfo.bin", Field: "SBL"}

opts.TableNames = {left_table, right_table}

obj = CreateObject("AddTables", opts)

obj.JoinTables("joined table")

 

 

 

See Also:

AddLayerDB

AddTables

Calculate Tables

Caliper.Charts

CC.ModifyTableOperations

CC.Table

Clustering

Data.Finder

Data.Geocoder

PostgreSQLConnect

PostgreSQLCommand

Routing.Bands

Routing.Path

Routing.Router

Table

Utilities.Mail