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.

 

It will 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);