Database Methods
The following methods control functionality for using Cadcorp SIS Desktop in conjunction with databases.
Cadcorp SIS Desktop can use database tables in several ways: for eg:
- Point or Text items can be created from a table which has suitable X and Y coordinate columns.
- SIS Desktop items can be stored in a table as "Blob" strings and viewed as a dataset.
- SIS Desktop can even store a complete dataset in a table, with item level locking.
- Existing Cadcorp SIS Desktop items can be linked to rows of relational data in a table.
CreateDataSourceOverlay | Inserts a dataset into the current SWD, that will fetch data from non-file data source. |
CreateDbBlobOverlay | Creates an overlay that views BLOBs stored in a database. |
CreateDbOverlay | Creates an overlay that stores editable BLOBs in a database. |
CreateDbTableOverlay | Creates a new Attribute Table overlay, i.e. a read-only view of a database table that has no geometry. |
CreateDbPointOverlay | Creates an overlay that views Points stored in a database. |
CreateItem | Creates an item from a BLOB string. |
CreateOpenGisSqlOverlay | Creates an overlay using an OGC conformant database. |
DefineRecordset | Defines a named recordset, for use with databases. |
DeleteRecordset | Deletes a named recordset. |
GetBlob | Gets the BLOB string of the current open item within a coordinate reference system. |
GetOverlayThemeLegend | Gets an overlay theme legend as a BLOB string within a coordinate reference system. |
GetSpatialReference | Gets the spatial reference for the current open item within a spanned cube in a coordinate reference system. |
ImportDataSourceOverlay | Imports a dataset into the current SWD, that will fetch data from non-file data source. |