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.