Database>Creating a New Table - II>Properties>Maximum number of records
Caravan Business Server>Help>Database>Creating a New Table - II>
Properties
Maximum number of records
|
Name
|
Maximum number of records
|
Text
|
By default the maximum number of records is unlimited. If not set, the max no. of records shows the current no of records. You need not set the value.
If you wish to restrict the number of records (depending on your application), you can set the maximum number of records value. This can be later increased also. Once set you cannot decrease the no. of records in case the data increases to those many records. e.g say you set it to 50000 records. Your data now equals 50000 (because if it goes beyond 50000, then automatically the oldest record is deleted). At this juncture you cannot decrease the no. of records. But in case the data has reached say 25000, then you can decrease the max no of records to 25000.
|
Sample
|
--NA--
|
|
Caravan Business Server>Help>Database>Creating a New Table - II>
Properties>
Multi Dimensional Arrays
|
Name
|
Multi Dimensional Arrays
|
Text
|
Multi-dimensional array is one of the most powerful and unique features of the Caravan database. While most databases store values in a single dimension, you can use multi-dimensional arrays for storing multiple values in different dimensions. Example: A telephone number can have different dimensions like Home, Office, Mobile, Voice Mail, etc. Thus, with a single field, you can store different telephone number types.
An array of field names can be created in a Caravan database. 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. All elements in an array have the same data type. In Caravan script, an array of field names is automatically created when one assigns multiple values to a field name.
|
Sample
|
<CARAVAN> table contacts=contacts.contacts contacts(Company)="1" contacts(firstname)="Chris" contacts(lastname)="Johnson" contacts(title)="Manager" //workphone is a multi dimensional field //multiple phone numbers are delimited with coma so set the delimiter to "," contacts(delim)="," contacts(Workphone)="6556412,6556403,6550291" //reset the delimiter contacts(delim)="null" contacts(homephone)="4015264" contacts(mobilephone)="9821124568" contacts(Faxnumber)="6550291" contacts(EmailAddress)="chris@email.com" contacts(contacttype)="2" //insert the record contacts(insert) </CARAVAN> In the example, 3 telephone numbers are inserted in the record.
|
|
Home
Back
|
|