Home
Main Introduction Features Constants Statements Database Objects Parser Serial-Communication Samples Misc
DataBase>Caravan Queue & replication information
Caravan Business Server>Help>DataBase>Caravan Queue & replication information
Text Caravan maintains a queue for records to be replicated. This queue can be accessed as a normal table in caravan database. Also Caravan database maintains a table, which contains the replicated information. This feature is useful if you want to display your replication information. The two tables are queue.data and msginfo.data both contained in the caravan system database.
Figure 1
Structure of queue.data

Queue.data Structure Information
Field NameDescription
_DBNAMEName of the database
_TABLEName of the table
_FieldsMulti dimensional field containing the fields to be replicated
_RecordRecord number in the table to be replicated
PriorityPriority at which the record will be replicated
_TimeTime at which the replication was initiated
_DestinationsMulti dimensional field containing the destinations to which the record should be replicated.
_definitionSystem info
_wholeDenoted weather the replication is whole or partial
_msgidRecord ID of the msginfo table . This will field will have a value only if the record was previously replicated and the current replication is the result of a modification in the record.
Figure 2
Structure of queue table
Figure 3
Structure of msginfo.data
Msginfo.data Structure Information
Field NameDescription
_DBNAMEName of the database
_TABLEName of the table
_RecordRecord number of the table which was replicated
_timeTime at which the replication was initiated
_DestinationsMulti dimensional field containing the destinations to which the record should be replicated.
_acktimeTime at which the replication took place
Back