ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Data model editor / Logical Data Model
  • Overview
  • Creating an item
  • Handling an item
  • Duplicating/Copying an item
  • Deleting an item
  • Renaming an item
  • Using a dictionary
  • Sorting the items displayed in the data file description
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
In the data model editor, the main operations that can be performed on an item are as follows:
Creating an item
To create an item:
  1. Double-click the data file where the item will be created. The description window of file items is displayed.
  2. Click the first empty row in the table of items or click .
  3. In the table, specify:
    • the item name,
    • the item caption,
    • the type of item and its size if necessary,
    • whether the item concerns personal data (GDPR checkmark). For more details, see Defining the "Personal data" items.
    Remark: For more details, see The different types of items.
  4. In the right section of the window, indicate the details of the new item (type of key, sort order, format, etc.).
  5. Validate the item description.
Handling an item

Duplicating/Copying an item

When creating an item whose name is identical to the name of an existing item, WINDEV, WEBDEV and WINDEV Mobile automatically propose to use the description of initial item.
An item can also be duplicated:
  • in the same file.
  • in a different file.
To duplicate an item in the same file, directly from the item description window:
  1. Select the item you want to duplicate in description window of a data file's items.
  2. Click . The item is automatically duplicated. Its name is the name of the original item suffixed with a number.
To duplicate an item in another file:
  1. Select the item you want to duplicate in description window of a data file's items.
  2. Click .
  3. In the window that appears, indicate the file description in which the item is automatically duplicated.
  4. Validate. The item appears in the description of the selected file.

Deleting an item

To delete an item:
  1. Select the item to delete in the description of file items.
  2. Click . The item is automatically deleted from the data file.
Remarks:
  • When creating an item whose name is identical to the name of an item that was previously deleted, WINDEV, WEBDEV and WINDEV Mobile automatically propose to restore the description of deleted item.
  • Deleting an item triggers the deletion of data during the next automatic data modification, even if a new item with the same name is created.

Renaming an item

To rename an item:
  1. Select the item to rename in the description of file items.
  2. Type the new item name.
  3. Confirm changes. The item is automatically renamed.

Using a dictionary

An item can be included in a dictionary in order to be re-used in a new application for example. To add an item to a dictionary, you just have to drag it from the data model editor and drop it onto the dictionary (in the "Dictionary" pane).
When it is included in a dictionary, the item description can subscribe to the modifications. Any modification performed in the item description will be applied to the dictionary object and to all uses of this object.
For more details, see Dictionary.
Sorting the items displayed in the data file description
Data file items can be displayed according to the following criteria:
  • logical order.
  • physical order.
  • alphabetical order.
To modify the display order of items:
  1. Double-click the data file. The description window of file items is displayed.
  2. The buttons found in the "Display" section are used to sort the items displayed in this window:
    • sorts in alphabetical order.
    • sorts he items and indexes in physical order.
    • sorts the items in logical order.
  3. The funnel in the "Name" column () allows you to perform a search: just click the funnel and start typing the desired word. All matching items will be displayed.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/19/2024

Send a report | Local help