Windev21 Aulas,Estudos e Desenvolvimento: DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO

quarta-feira, 5 de agosto de 2020

DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3

https://youtu.be/NMvNvWaXGAM

Bom Dia/Boa Tarde/Boa Noite

Esse Ao Vivo vai estrear as 17:00 do dia 14/09/2020 segunda

DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3

Tutoriel WINDEV : Leçon 3.3.c. Projet et analyse - Création du fichier
https://windevdesenvolvimento.blogspot.com/2020/08/dicas-2999-windev-tutorial-22-projeto-e.html

ASSUNTOS

CRIANDO A TABELA PEDIDO
CRIANDO OS CAMPOS NECESSARIOS DO PEDIDO
CRIANDO DATA DO PEDIDO
CRIANDO STATUS DO PEDIDO
PENDENTE FINALIZADO CANCELADO
CRIANDO CAMPOS DE TOTAIS

https://doc.pcsoft.fr/fr-FR/?1410087521&name=lecon_33_projet_analyse

Video original da Franca

https://www.youtube.com/playlist?list=PLwJwZaqiZW-lxU1XF0M0htb5S5f8pavuE

ErpMatos - TgsSistemas

skype:amarildo.matos.informatica

email: amarildo.matos@gmail.com

whats: 51984197742

Youtube: Amarildo Matos

http://www.amarildomatos.com.br

https://groups.google.com/forum/#!forum/amarildowindev

www.windev.com

https://www.pcsoft.fr/webinaires.htm?p=forumpcs

https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/page/1.awp

https://www.windev.com/windev/WD-Express.htm

https://www.windev.com/windevmobile/WM-Express.htm

http://windevdesenvolvimento.blogspot.com.br/2017/07/menu-blog.html

Creating a data file: creating the data file and items

To create a data file from the window for creating a new element:

Click "Data" then "Data file".

Remark
You also have the ability to create a data file from the data model editor: in the ribbon, on the "Analysis" pane, in the "Creation" group, click "New file".
The data file creation wizard starts.
In the wizard, select "Create a new data file description".
Go to the next step of the wizard.

We are going to create the "Orders" data file. Type its name ("Orders") in the wizard. This name will be used:

to handle the data file by programming. The variable associated with the data file will be "Orders".

to build the name of associated physical data file ("Orders.fic" file). The caption and description of elements represented by the file records are automatically displayed.


	Remark	In the wizard, the control "A record represents" is used to get an understandable caption during the description of links between data files. A caption is automatically proposed from the data file name. In our case, type "An order".

Data file creation wizard - General settings

In "Automatic identifier", keep "8-byte automatic identifier". If an automatic identifier is defined on the data file, it means that the data file includes a unique key, automatically managed by WINDEV.


	Remark	To create the identifier (an identifier is a unique key), you have the ability to create a numeric item whose type is "Automatic identifier". This identifier is automatically managed by WINDEV. Whenever a record is added to the data file, WINDEV automatically assigns a value to the data file identifier. This value is unique.

Go to the next step and select the type of database associated with the data file. We are going to work on HFSQL Classic data files. Go to the next step.
Click "Done" to validate. The data file is automatically created in the analysis. The description window of items and indexes opens up.

We are going to create the items of the "Orders" data file. In the data file description window, you will notice that an item was automatically created: "OrdersID". This item corresponds to the automatic file identifier. This item consists of the letters "ID" and the name of the data file.

We are going to create the other items of this data file.

First, we are going to create the "Date" item. This item will contain the order date.

In the item description window, double-click in the "Name" column of first empty row. This column automatically becomes editable. Type "Date".
Click the "Caption" column. The item name is automatically displayed. We are going to modify the item caption by clicking on it: type "Order date". In the "Type" column, the "Text" type is automatically selected. Expand the list and select the "Date" type.

This item will be a key item (index) in our data file: the keys are used to accelerate the accesses to data and the sorts.

In the case of an SQL database, the engine makes the best use of indexes.

For a sequential browse of a data file, all you have to do is specify the browse index (which means the key).


	Remark	The concept of key is part of the item characteristics. When creating an item, you have the ability to specify whether it is: not key, unique key: the value of this key will be unique in the entire data file (i.e. in all the data file records). key with duplicates: the value of this key can be found several times in the data file.

The key definition is performed as follows: re-select the row of the "Date" item to activate the description controls on the right-hand side of the window. Then, simply specify the type of key used. In our case, the date is a key with duplicates.
You must also define the search direction of the key. The search direction is used to define the default sort for this item. In our case, when a browse is performed on this key, the default sort order will be "ascending".

We are now going to create the "Status" item that is used to find out the order status.
1. Position the cursor on a new table row. Enter:
  - the name: Status
  - the caption: Order status
  - the type: Radio Button, List Box, Combo Box. In the window that appears, you can select the type of control created by default for this item. It will be a radio button in this case. Validate the window.
2. In the lower section of the screen, click the link to display the parameters of the control linked to the selected item.
  
  The information typed in the new window that is displayed will be automatically used when creating windows linked to the data file. You will find here the control type and the caption.
  We are going to type the following options in the "Content" tab:
  - Click the "Content" tab.
  - Click the "+" button to add the first option.
  - The option 1 corresponds to Pending. Type "Pending" in the edit control found on the right.
  - Click the "+" button to add the second option.
  - Type "Validated" instead of "Option 2".
  - Click the "+" button again.
  - Type "Canceled" instead of "Option 3".
3. Validate the description window of the control linked to the item.
4. Similarly:
  - Position the cursor on a new table row and create the item "TotalBT". This item is a "Currency" item.
  - Position the cursor on a new table row and create the item "TotalIOT". This item is a "Currency" item.
5. That's it, the description of "Orders" data file is complete. Validate the description window of items.
6. The "Orders" data file appears in the data model editor. It is possible to enlarge the displayed data file. Simply click the data file, select the black handle at the bottom of the data file and move the mouse down.

Páginas

quarta-feira, 5 de agosto de 2020

DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3

https://youtu.be/NMvNvWaXGAM

DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3

https://youtu.be/EV62zq3xlpc

https://www.youtube.com/playlist?list=PLwJwZaqiZW-lxU1XF0M0htb5S5f8pavuE

Nenhum comentário:

Postar um comentário

Teste

Marcadores


	Remark	You also have the ability to create a data file from the data model editor: in the ribbon, on the "Analysis" pane, in the "Creation" group, click "New file".