Data dictionary

Data dictionary

The data dictionary is an important tool for the creation of multilingual systems, using this resource it is possible to create a data repository for use in the applications generated in the project or in new applications.

The data dictionary is associated with one or more tables, when creating an application, using one of these tables, at the location of the field label a lang will be displayed, created by Scriptcase automatically, which makes it possible to change the language of the applications at run time. In pre-existing applications in the project it is possible to synchronize them.

We will see in this example below, how to use this feature.

1. To access the data dictionary, access the main menu Tools > Data dictionary


2. Next, we will be redirected to the initial screen for creating the data dictionary, where we must inform the name and connection that we will use.

3. Next, a screen will be displayed containing the List of all tables that the previously selected connection has access to.

     In this step we must select the tables in which we will create the data repository. In this example I will only use the cities table.

4. Then we will be redirected to the screen below. In this step, we must choose whether we want Scriptcase to create indexes on the field labels, so that we can create a project with multiple languages, which can be changed dynamically.



5. In this step we can view the tables synchronized with the data dictionary.

Edit- The Edit button at the top of the screen makes changes to the data dictionary properties.

Database tables- Clicking on the database tables option will display a list of unsynchronized tables and you will 'return' to step 3

Synchronize dictionary- The Synchronize dictionary option is also when selecting one or more tables. In this option you 'return' to step 4 and can update dictionary information if you have made changes to the tables. Remember to clear the cache before performing this synchronization.

Synchronize applications- The Synchronize applications option is enabled when selecting one or more tables. In this option, it is possible to create indexes on existing applications. Visualize the next step.

Edit (Scriptcase Fields)- In Edit, next to the version, it is possible to make some changes in the Scriptcase fields, these changes will be used for all applications created using the selected table. check this option in the image below:


6. The Synchronize applications option is enabled when selecting one or more tables. In this option, it is possible to create indexes in the applications already existing in the project, using the selected tables.

    After selecting the tables and clicking on proceed, the screen below will be displayed:

This screen contains all the existing applications that use the selected tables, and beside the properties that will be updated. After completing the process, the following screen will be displayed:

      You can check the log, using the Display log button, of the changes made or finalize the data dictionary by clicking Close.

Option Display log:



7. To edit the langs that were created, go to Locales > Application language.


8. A folder will be created in Project messages, with the name of the table. By clicking on this folder it is possible to view the langs created and the name of the fields in the project languages, previously selected.

Note: When creating a lang manually, in the dictionary select the tables, click Synchronize applications, so that the lang is automatically included in all applications in the selected table.


    • Related Articles

    • Filtering data within a grid

      To filter certain information within a Grid, the WHERE clause can be used. - An application of the Grid type must be created    2. Then within the query that is going to be done, the filter is placed in a field and a global variable will be used to ...
    • 'No tables found in database access' error while trying to import Access data.

      This error occurs because it is necessary to have the Microsoft Access Database Engine installed, which contains a series of components that facilitate the transfer of information between files of Office for the other applications. For the ...
    • Macro sc_date

        Scriptcase provides a very useful macro for manipulating dates, which is a very laborious process, however with the use of the sc_date macro (Increments and Decrement Dates), it is much simpler, example:   sc_date (Date, format, operator, D, M, A) ...
    • Limit number of records to be displayed in the Grid

      To limit the number of records to be displayed, we will use the Limit function within the query where they bring the data of a certain table. For example in this way: Then only 5 records are shown:
    • Update of the security module synchronization application

      In order to improve security in our projects, we made several changes to the application files. One of these changes affected a crucial file that tells applications how to sync. To ensure that the synchronization continues to work correctly, we made ...