Class DBC.HistoryFields

Fields for History, History lists for lists and searchable controls. Maintains history for Navigator or other search (find dialogs). A single table may have more than one record here, as indicated by the extra_id field. The HistorySize (preference may be set in maintenance client) defines how many records you can have in a history list.

Inheritance
object
DBC.HistoryFields
Inherited Members
Namespace: SuperOfficeCRMData
Assembly: SoDataBase.dll
Syntax
public static class DBC.HistoryFields

Fields

AssociateId

History.AssociateId: Owner of history list

Declaration
public const string AssociateId = "associate_id"
Field Value
Type Description
string

ExtraId

History.ExtraId: Extra ID, used to manage multiple histories per table

Declaration
public const string ExtraId = "extra_id"
Field Value
Type Description
string

HistoryId

History.HistoryId: Primary key

Declaration
public const string HistoryId = "history_id"
Field Value
Type Description
string

Rank

History.Rank: Sort order, indexed so it can used for sorting in the query

Declaration
public const string Rank = "rank"
Field Value
Type Description
string

RecordId

History.RecordId: Record within the table

Declaration
public const string RecordId = "record_id"
Field Value
Type Description
string

TableId

History.TableId: Table this is a history of

Declaration
public const string TableId = "table_id"
Field Value
Type Description
string

UpdatedCount

History.UpdatedCount: Number of updates made to this record

Declaration
public const string UpdatedCount = "updatedCount"
Field Value
Type Description
string