ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Editors / Data model editor / Logical Data Model
  • Overview
  • Creating an item
  • Handling an item
  • Duplicate/Copy an item
  • Delete an item
  • Rename an item
  • Use a dictionary
  • Sorting the items displayed in the data file description
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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 item type and its size if necessary,
    • whether the item concerns personal data (GDPR checkmark). For more details, see Defining the "Personal data" items.
    Note: For more details on the different types of rubrics, 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

Duplicate/Copy 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 a heading in the same filedirectly from the heading 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.
Remarks:
  • Alternatively, you can use the "Duplicate" option in the context menu of the item to be duplicated.
  • The "Copy", "Paste before" and "Paste after" options in the context menu can also be used to perform these operations.
To duplicate an item from one file to another:
  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. Confirm. The item appears in the description of the selected file.

Delete 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.
  • The button or the "Cut" option in the field's context menu can also be used to delete the field.

Rename 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.

Use 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. Use the funnel in the "Name" column () to perform a search: simply click on the funnel and enter the letters of the heading you're looking for. 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: 12/05/2024

Send a report | Local help