Create a Table

A database can contain many tables, each storing information about a different subject.
Each table can contain many fields of different data types, such as text, numbers, dates, etc.
This article explains how to create a new table in the database.
See the steps below.

1: Open the application.
2: Right-click and select “Developer.”
3: Double click “Database Manager.”
4: Click “Actions” from the menu and select “Edit Local Database Schema”.
5: Click the button “New Record.”
6: In the field “DESCR” fill the description of the table.
7: In the field “FILENAME” fill the name of the table.
8: In the field “UFIELD” fill the primary key of the table.
9: In the “Fields” area, you can specify the columns and their data types.

Name: Fill in the field name.
Description: Fill in the field description (the field caption when designing a form or report).
Type: Select the field type.
Length: Fill the field length.
Related Table: Select the table that is related to the field.

10: In the “Indexes” area, you can specify the indexes.

Name: Fill in the index name.
Fields: Fill in the field name for the field that you want to index. If you create a multiple-field index, fill the fields name separated with a “;”.
Properties: An index can have two kinds of properties, unique and ascending.
If you want your index to have unique values, you must write the expression “Un.”
If you wand ascending order, you must write the expression “Asc.”
If you want both properties, you must write “Asc;Un.”

11: Save changes.
12: Read schema (see the article “Read the Database Schema”).
13: Upgrade database (see the article “Upgrade the Database”).

For more help, please see http://www.youtube.com/watch?v=sE7CDKkRVxE