AddMSSQLLayerToWorkspace()
Summary
Add layer to current workspace after exporting it to MSSQL spatial database.
Syntax
AddMSSQLLayerToWorkspace(string layer_name, string file_name, string table_name, string schema_name, array opts)
| Argument | Type | Contents |
| layer_name | string | Name of layer being exported |
| file_name | string | Name of server + database |
| table_name | string | Name of table to which layer is being exported |
| schema_name | string | Name of schema to which layer is being exported |
| opts | options array | Options array |
| Option | Type | Contents | | |
| Type | string | Type of layer: Line, Point or Area |
Example
opts = { Type: "Line"}
Layer_name = AddMSSQLLayerTOWOrkspace("My Streets", "localhost|spatial_db1", "table_1", "public", opts)
Error Codes
| Error Type | Meaning |
| Error | Invalid service name, table name or schema name; or failed to log user in with provided credentials; or failed to extract option from options array; or failed to add external layer to map |
| Not Found | Map view is not found based on provided map |
See Also
| Function | Summary |
| AddMSSQLLayer() | Add layer to map after exporting it to MSSQL spatial database |
| ExportMSSQL() | Export map data to MSSQL spatial database |
| AddPGSQLLayer() | Add layer to map after exporting it to PGSQL spatial database |
| ExportPGSQL() | Export map data to PGSQL spatial database |
| PGSQLClose() | Close the connection with PostgreSQL , if it exists |
| PGSQLConnect() | Establish a connection with PostgreSQL |
| PGSQLExportFromQuery() | Run an SQL query on the open PGSQL database connection and export results to a file |
| PGSQLGetDatabases() | Retrieve a list of PGSQL databases from the connected database server |
| PSGQLGetSchemas | Retrieve a list of schemas from a PGSQL database |
| PGSQLGetSpatialDatabases() | Retrieve a list of PGSQL spatial databases from the connected database server |
| PGSQLGetTables() | Retrieve a list of tables from a PGSQL database |
| PGSQLGetUniqueFields() | Returns all unique fields from the PGSQL database table, as defined in the table constraints |
| PGSQLRunQuery() | Run an SQL query on the open PGSQL database connection |
| PGSQLSetDatabase() | Set database as the current selection in the "Open PostgreSQL Table" dialog box |
| PGSQLSetSchema() | Set the name of the database schema to be displayed to the user in the "Open PostgreSQL Table" dialog box |
| PGSQLSetTable() | Set the name of the table to be displayed to the user in the "Open PostgreSQL Table" dialog box |