Datatypes understood by stored procedures

As part of stored procedures, you can create custom data types to represent common concepts (eg an overlay) and populate them with as much or as little information as  required.

This allows you to produce more readable and intuitive code in your clients as well as being able to pass a lot of information in a single message.

The following data types can be used:

  • for procedure parameters

  • to return types

  • for User Defined Type (UDT) field types

In C#:   

  • bool
  • byte     
  • Cadcorp.GeognoSIS.StoredProcedures.SisExtent     
  • Cadcorp.GeognoSIS.StoredProcedures.SisMimeType     
  • Cadcorp.GeognoSIS.StoredProcedures.SisVector     
  • double
  • float
  • int
  • long
  • short
  • string
  • System.DateTime
  • void

void is used as a return type only. It does not apply to VB.NET, where you replace Function by a Sub routine (sub) instead.

Also included are one-dimensional arrays of the above data types.

Note: The stored procedures can use null pointers as parameters and as return values.