PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Overview
  • Creating an item
  • Handling an item
  • Duplicate/Copy an item
  • Delete an item
  • Rename a topic
  • Use 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 screen, specify the details about the new item (type of key, search direction, format, ...).
  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.
New in version 28
It is also possible to duplicate an item:
  • in the same file.
  • in a different file.
To duplicate a field in the same file, directly from the description field window:
  1. Select the field to be duplicated in the description of a data file fields.
  2. Click on the XXX button. The field is automatically duplicated. Its name corresponds to the name of the original heading suffixed with a number.
To duplicate a field from one file to another:
  1. Select the field to be duplicated in the description of a data file fields.
  2. Click on the XXX button.
  3. In the window that appears, indicate the file description in which the field is automatically duplicated.
  4. Validate. 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.

Rename a topic

To rename an item:
  1. Select the item to rename in the description of file items.
  2. Type the new item name.
  3. Validate the modification. 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:
    • is used to perform an alphabetical sort.
    • is used to display the items and indexes in logical order.
    • is used to display the items and indexes in physical order.
  3. The magnifier found in the "Name" column () is used to perform a search: simply click the magnifier and enter the first letters.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment