Database>Viewing Table Structure
Introduction Installation Beginning Admin Quick Ref FTP Server SMTP Server Database Security
Statements Objects String Parsing Events Queues Samples Special names Error Handling Accessories   Back
Caravan Business Server>Help>Database>Viewing Table Structure
Text   When the table structure for a table in the database is created, it is displayed as a link in the Caravan Database Manager screen.
      
Note:       All fields beginning with an underscore are system generated fields.
Sample
Figure 01
  Click on the table link, to view the table structure. The details of the field structure-field name, type, dimension, flags, default value are displayed.  You can delete or modify these fields. You can also add fields.
Figure 02
   Editing Tables
Select a field and click on Delete Field to delete the selected field.

Click on Add Field to add a field.

Click on the Backup button to create a backup of the selected table. The backup table has the same name as the original table but is prefixed by an underscore (_). Example: File custbal will be backed up as _custbal.

Modifying a field

When you select a field and click on the Modify Field button, the field structure for the selected field is displayed. Say, for Telephone,  Type = String, Size = 64,Dimension = 1. You can modify the details and click on Modify to modify the field.
Figure 03
       Adding a field

Click on Add Field in the selected table to add a field to the table.  Enter the new field structure details in the screen displayed.

Click on Add to add the field.
Figure 04

Deleting a field
Select a field and click on Delete Field to delete the selected field.

Backup a Table

Click on the Backup button to create a backup of the selected table. The backup table has the same name as the original table but is prefixed by an underscore ( _ ). Example: File firsttable is backed up as _firsttable.

Set Maximum Records

Sometimes you may want to keep the number of records to be stored in a table to be fixed. In that case you can set the number of fields to say "5000" and click on the Set button. The number of records can be increased later, but once set, you cannot decrease the number.
Figure 05

Send Data

Sometimes you may want to replicate the entire table to a Caravan application running in another location connected through your network. A classic example would be to replicate the master tables like products, vendor information, etc to a newly opened branch instead of re-entering the entire data. This feature can also be used to take backup of the entire table to the backup Caravan Server.

Enter the IP address and the port number of the Caravan Server to which you want the data to be replicated and click on Send.
Figure 06

View Data
Click on Click to View/Edit Contents of table name to view each record.

A screen displaying the field details is displayed. Click on the Next, Previous, Goto options to move through the records. Click on Modify, Delete to modify or delete the record. Click on New to add a new record
Figure 07
Figure 08
Quick Reference
Home       Back