4D v14Defining the Database Structure |
||||||||||
|
4D v14
Defining the Database Structure
|
Field Name | Field Type |
First Name | Alphanumeric (255 characters) |
Salary | Real |
Department | Alphanumeric (255 characters) |
Note: If other 4D remote applications were working simultaneously with the server database, the fields you have just created will appear on the other client machine in a few moments. The changes are implemented on the server in real time, but do not appear on other screens immediately, to avoid updating the screen too frequently.
After you have defined the [Employees] table, you need forms to add and work with its records. To do so, you could use the New Form Wizard and create forms at your convenience. However, 4D comes with a convenient shortcut for quickly creating default input and output forms.
1. Click on the Tables button of the 4D tool bar.
OR
Choose the Show Current Table command from the Records menu.
The records window is then displayed. 4Ddetects that the table still has no forms and asks if you want to let the program create them for you.
2. Click Yes.
You have now an input form for adding or displaying records one by one, and an output form for displaying or entering multiple records in list mode.
Your server database is ready for data manipulation. Go to the section Data Manipulation with 4D Server.
Product: 4D
Theme: 4D Server in 10 minutes
4D Server Reference ( 4D v14 R2)
4D Server Reference ( 4D v14)
4D Server Reference ( 4D v14 R3)
4D Server Reference ( 4D Server v14 R4)
Inherited from : Defining the Database Structure ( 4D v13)