The final step in this tutorial will use 4DLOOP with records from the 4D Database. This is the first time in this series of tutorials that we have used 4D's built-in database. 4D's relational database is very powerful, and the fact that it is integrated with the middleware engine makes it surprisingly easy to put 4D data into a web page.
First, we will need to set up a database table for use. It's probably best just to modify an existing table - Table 1, the default table that is always created.
To do this, go to the 4D Design environment, and choose Database Structure from the Tools menu. You should see the database structure window, which will look something like this:
Double-click on Table 1. The Table Properties palette should appear:
Change the name of the table to LoopData - without a space. Click the Apply button to save the changes.
After you click Apply, the table name should change to LoopData. With the table still selected in the Database Structure window, go to the Structure menu and choose New Field. When you do, the Field Properties dialog box should appear. Name the field "AlphaField" so it looks like the picture below:
Click the Apply button. After you do, you will be ready to create another new field. Name it NumberField, and change the type to be Long Integer. It should look like this:
Again, click the Apply button. Then click Done. Back in the Database Structure window, your LoopData table should look like this:
International |
Company | Contact
4D | Site Map | Privacy
Policy | © 4D UK 1995-2008 | Change font size: [A]
[A]
[A]
| 