ExecuteMSSQL

Top  Previous  Next

This is the main method and is a single call to do all the processing.

 

The first 5 parameters always need to be set.

For the rest at least one need to be set. This way you can create just the attribute.bin file or similar if you have the rest in advance.

 

If geography is true, the field with the geography is automatically detected. For the remaining the fieldname need to be set.

Object types in the table can be LineString, while MultiLineString are skipped.

 

Do not specify the schema, it will automatically look up the schema on its own.

 

It will also automatically look for a MapInfo mapcatalog with additional meta information.

 

Example set of parameters for a table "roads" that has been uploaded to a local MS SQL Server Express database.

 

Parameter

Value

Server

"127.0.0.1\SQLEXPRESS" or

"127.0.0.1" or

"127.0.0.1:12345"

Database

"GIS1"

Username

"GIS_user1"

Password

"secret_code"

Tablename

"roads"



Geography

true

Attribute

"attribute4"

Roadname

"streetname"

Externalid

"ID"

Limit

""

ZFrom

"ZFromLevel"

ZTo

"ZToLevel"

 

Syntax: ExecuteMSSQL(Server, Database, Username, Password, TableName: string; geography: boolean; attribute, roadname, externalid, limit, ZFrom, ZTo: string);