Creating and handling an item

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WEBDEV

WINDEV Mobile

Others

See also

Creating and handling an item

Overview

In the data model editor, the main operations that can be performed on an item are as follows:

Create an item.
Duplicate/Copy an item.
Delete an item.
Rename an item.
Use a dictionary.
Sort the items displayed in the data file description.

Creating an item

To create an item:

Double-click the data file where the item will be created. The description window of file items is displayed.
Click the first empty row in the table of items or click .
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.
In the right section of the window, indicate the details of the new item (type of key, sort order, format, etc.).
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:

Select the item you want to duplicate in description window of a data file's items.
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:

Select the item you want to duplicate in description window of a data file's items.
Click .
In the window that appears, indicate the file description in which the item is automatically duplicated.
Validate. The item appears in the description of the selected file.

Deleting an item

To delete an item:

Select the item to delete in the description of file items.
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:

Select the item to rename in the description of file items.
Type the new item name.
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:

Double-click the data file. The description window of file items is displayed.
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.
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.