Click or drag to resize

SODictionary Interface

The Data Dictionary provides information about the database version, the tables installed, and the fields available on a table. You must use the SODictionarySDK to add or remove tables.

Namespace:  SuperOffice.COM.SuperOfficeDB
Assembly:  SuperOfficeDB.Interop (in SuperOfficeDB.Interop.dll) Version: 8.0.0.0
Syntax
public interface SODictionary : IDictionary

The SODictionary type exposes the following members.

Properties
  NameDescription
Public propertyCode exampleRevision
Revision - dictionary revision The database dictionary revision, default is 10
(Inherited from IDictionary.)
Public propertyCode exampleVersion
Version - dictionary version The database dictionary revision, 86 is CRM 5
(Inherited from IDictionary.)
Top
Methods
  NameDescription
Public methodCode exampleGetFieldId
maps 'person.contact_id' -> 1537 Return the internal fieldid from a database field, like Person.Concactid has fielded = 1537
(Inherited from IDictionary.)
Public methodCode exampleGetFieldLength
Returns the size of the column. String length Returns a string fields length, the last bit is a stop bit so if it returns 50 you may only add 49 characters
(Inherited from IDictionary.)
Public methodCode exampleGetFieldName
maps 1537 -> 'contact_id' Will return the fieldname from the internal fieldId provided, meaning NAME if you ask to get the fieldname of the field 1281 (Contact.Name)
(Inherited from IDictionary.)
Public methodCode exampleGetFieldType
Returns the column type for a given field. Maps 1536 -> enTypeInt, enTypeVstring Get the type of field - enTypeInt, enTypeVstring and so on.
(Inherited from IDictionary.)
Public methodCode exampleGetFullName
maps 1537 -> 'person.contact_id' Get the table and field name based on a fielded. Meaning GetFullName for 1281 would return ‘contact.name’
(Inherited from IDictionary.)
Public methodCode exampleGetTableIdFromFieldId
maps 1536 -> 6 Get the table id from the internal field_id: 1281 -> table number 5, see the database documentation for table numbers
(Inherited from IDictionary.)
Public methodCode exampleGetTableName
maps 1537 -> 'person' Will return the table name from the internal fieldId provided, meaning ‘CONTACT’ if you ask to get the table name of the field
(Inherited from IDictionary.)
Top
See Also