REFERENCE LIBRARY
LEARNING CENTER

Quickstart building a web application (Mobile touch)

To continue with this content, please log in with your Data Access ID or create a new account.
Cancel Data Access ID
You may not be authorized to see this content. Please contact Data Access Europe for more information.
Cancel Data Access Europe
You are not authorized to see this content.
Cancel Data Access Europe

DataFlex courses

Information

Quickstart building a web application (Mobile touch)
Introduction (0m 48s)
Configuring the data dictionary (5m 43s)
Next lesson:
Create a web project
Cancel

Quickstart building a web application (Web/Mobile)

Lesson 3: Configuring the data dictionary

In this lesson we’re going to configure the data dictionaries. The data dictionaries contain the business rules of the application. The business rules are the central point of the application. In this lesson we’re going to configure the data dictionaries per table. 

Person table

  1. Go to the Table Explorer and expand Person.
  2. Expand Data Dictionaries and open the Data Dictionary by double clicking cPersonDataDictionary. The Data Dictionary modeler comes up.

  3. The Data dictionary defines all kind of Business Rules. One of them is auto numbering. Click on Auto Increment and select the PersonId. The auto increment will assign a new unique number for each record. The System file contains a PersonId field and this will be used for the auto increment.

  4. Set the Protect Value Key to True. Now this setting will not change after the record is created.

  5. Another typical function of the data dictionary is to tell it which fields are required. When a record is saved it will validate if a value is actually entered. For the LastName set Required to true. Do the same for FirstName.

  6. To make the creation of the application later on we’re going to fill out the Short Label field. This will be used by the wizard later on in the application generation process. Set this to First name with a space. Do the same with Last name.

Media table

  1. Click on cMediaDataDictionary.

  2. Just as with the Person table go to Auto Increment. Select the Media Table. It also shows the Person table, because the Parent table can also contain the auto increment field, but choose the System file.

  3. Set the Protected Key Value to true, so it should never change after the record has been created.

  4. Make Title a Required field.

  5. For Type we’re going to create a Lookup/Validation object. Select Type and select the Validation Objects tab.

  6. Click on Add Validation Object
  7. Select the two columns table. 
  8. Name the object MediaTypes.
  9. Select the Type column.

  10. Enter the values that are possible for this field:
  11. Image, Image file
  12. Audio, Audio file
  13. Video, Video file

  14. Going back to the Type Column we see the validation object Media Types we’ve just created.

  15. Go to Visual Control to make this field a Combo field.

  16. Go to PurchaseDate and create the Short Label Purchase date.

  17. Go to Price and configure a Mask. A mask determines which characters can be entered, but it also determines how a value is shown within the application. Select Mask Type, Mask_Currency_Window.

This ends this lesson.



©2026 Data Access Worldwide, all rights reserved
Privacy policy Cookies About dataaccess.com Online Documentation