Database>Creating a New Table - II
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>Creating a New Table - II
Text In the Create Table screen, you can specify the table structure, such as field names, width, dimension, field types, flags, and default values. After the table structure is specified, click on Done. Click on database hyperlink to display all the tables within the database.
Sample
Figure 01

Field Name Enter a field name. Examples: Name, Telephone, etc.
Width
Enter the length of the field. Note: Width must be 1 for fields other than String.
Dimension
Caravan has a unique feature that allows the user to create multi dimensional fields. Each field in Caravan can act as an
array. Enter 1 if the field has only one value. Enter a number greater than 1 to specify the number of values the field can store.
Example: a person can have eight telephone numbers. The dimension specified for the field telephone will be 8.An array of field names can
also be created. Arrays allow you to refer to a series of field names by the same name and use a number (an index) to tell them apart.  
Refer to Multi-Dimensional Array, which follows, for details.
Field Type
Enter the data type of the field. Four datatypes are permissible.STRING – This is a string data type. The contents of this
field are alphanumeric and can contain all the characters upto ASCII 127. Example: Smith
NUMERIC – This is a numeric data type. Only long integers can be entered.
 
TIME– This is a date-time data type. The contents of this field can be accessed in the same manner as shown in Special Variables – time.

RELATIONAL–  This is a relational field. Relation can be set between various tables in the same database. Refer
to Relational Database for details.

FILE– This is a file data type. The contents of this field can be text, images, binary files, etc. The contents of the field can be
accessed in the same manner as shown in File object.
Flags Select from the following checkboxes.
 
M – Mandatory –  This field cannot be empty.

U – Unique   –  The contents of this field should be unique.
 
L –  Local     –  The contents of this field should be local.

K – Key field – There can be only one key field in a table.
Default Value
When a new record is inserted in the table, the default value specified here is displayed.
Quick Reference
Properties Multi Dimensional Arrays
Maximum number of records
Home       Back