Creating a New Paradox Table
First we go to File| New | Table in the Database Desktop menu.
Next you will see the Create Table
dialog box.
Here we can choose other table types from
the dropdown list.
Leave it on Paradox 7 (the default), for this exercise and click on the OK button.
You will now see a form with the words
Create
Paradox 7 Table (Untitled): in the title bar.
This the the Create Table dialog box which
we will use to specify the structure of our new table.
We could borrow the structure of an existing table if we wanted.
We will type our first field name in
the
Field
Name column.
Click next to the number 1 and we will
enter our first Field Name which will be Name.
You can use the Tab key to move to
the
next column or Shift + Tab to go back to the previous column.
If a column is not required in the field
type you have chosen, Database Desktop will skip that column and move
to
the next column.
Next press the Tab key and then press down the Space Bar and a list will appear.
We will choose Alpha.
Press the Tab key again.
For the size we will enter 30 which should be enough.
Now to enter the next field all we need to do is press the Down Arrow key and we are ready to name our second field.
We could name this Address and
so
on. This is the same as the above field example.
You can also add:
Phone
Town
etc.
You should experiment with all the
different
Field Types.
A | 1 - 255 | Alpha |
N | Number | |
$ | Money | |
S | Short | |
I | Long Integer | |
# | 0 - 32* | BCD |
D | Date | |
T | Time | |
@ | Timestamp | |
M | 1 - 240** | Memo |
F | 0 - 240** | Formatted Memo |
G | 0 - 240*** | Graphic |
O | 0 - 240*** | OLE |
L | Logical | |
+ | Autoincrement | |
B | 0 - 240*** | Binary |
Y | 1 - 255 | Bytes |
When we are finished entering fields we can save the table.
Click on the Save As button.
The Save Table As dialog box appears.
We will name our example as example.
Leave the Save As Type as Paradox(*.db)
And we will leave Alias as Work.
This is a simple example to get you started. Remember to read the help files that come with Database Desktop.
Copyright © 1998-2002 James M
Sandbrook
& Sandbrook Software. All rights reserved.
Do not duplicate or redistribute in any
form.