https://youtu.be/umzSz1zrA5g
Bom Dia/Boa Tarde/Boa Noite
Esse Ao Vivo vai estrear as 11:00 do dia 26/08/2020
DICAS 3021 - WINDEV TUTORIAL 44 - Pesquisa Multicriterio - Criacao Consulta - Parte B
Tutoriel WINDEV : Leçon 4.4.b. Recherche multicritère - Création de la requête
ASSUNTOS
EXPLICANDO COMO FUNCIONA QUERY
FAZENDO UMA QUERY PEDIDOS CONSULTA
Video original da Franca
https://youtu.be/97ZY-02xI6E
Playlist Windev TUTORIAL
SELECT
Orders_pedido.OrdersID AS OrdersID,
Orders_pedido.Date AS DATE,
Orders_pedido.Status AS Status,
Orders_pedido.TotalBT AS TotalBT,
Customer_cliente.FullName AS FullName,
PaymentMode_tipo_pagamento.Caption AS Caption
FROM
Customer_cliente,
Orders_pedido,
PaymentMode_tipo_pagamento
WHERE
PaymentMode_tipo_pagamento.PaymentModeID = Orders_pedido.PaymentModeID
AND Customer_cliente.CustomerID = Orders_pedido.CustomerID
ORDER BY
DATE ASC
Creating the query used to find orders
Creating the query
- The query editor will be used to create the query.
- Click
among the quick access buttons. The element creation window appears: click "Query". The query creation wizard starts. - Select the "Select" option.
Indeed, this query will be used to select records. Go to the next step. - The query description window is displayed. To build the query, we are going to select the elements that will be displayed in the result.
- Double-click the items in the analysis, to the left of the description window. The items taken into account are displayed in the middle of the screen.
Remark: To display the items of different data files, simply click the arrow
in front of the data file name.
We want to display:- information regarding the order. Expand the "Orders" data file (click the arrow ) and double-click the items: OrdersID, Date, Status and TotalBT.
- information regarding the customer who placed the order. Expand the "Customer" data file (click the arrow ) and double-click the "FullName" item.
- information regarding the order payment method. Expand the "PaymentMode" data file (click the arrow ) and double-click the "Caption" item.
- information regarding the order. Expand the "Orders" data file (click the arrow
- The data will be sorted by date.
- In the list of query elements, select the "Orders.Date" item, then click the "Sort" button and select "Sort on the selected item".
- In the window that appears, indicate an ascending sort on the item.
- Validate.
- A blue arrow with the number 01 appears on the right of "Orders.Date" item. This arrow indicates that an ascending order has been applied on this item. The number "01" indicates that this sort will be applied first.
- Give a name to the query: type "QRY_FindOrders" instead of "QRY_NoName1" in the "Query name" area:
- Validate the query description window ("OK" button).
- The save window is displayed. Validate the proposed information.
- The graphic query representation is displayed:
- Click
Query test
Like all elements found in a WINDEV project, you have the ability to run the test of query that was just created:
- Click
. - The result is displayed in a window:The result lists ALL orders.
In our case, we want to display the orders corresponding to the search criteria only. To do so, we must use a query with parameters.
Remark
A popup menu is displayed when a right click is performed on the query result. You have the ability to export the result to: - an XLSX file (Excel).
- a Word or OpenOffice file.
- an XML file (eXtensible Markup Language).
- an HFSQL file.
- Close the window.
DICAS 2978 - WINDEV TUTORIAL 1 - 1.1B - WINDEV TEMA ESCURO E IDIOMA DO AMBIENTE
DICAS 2979 - WINDEV TUTORIAL 2 - 1.2- CRIAR JANELA E INSERIR TEXTO E EXIBIR
DICAS 2980 - WINDEV TUTORIAL 3 - 2.1- VARIAVEIS PARTE 1
DICAS 2981 - WINDEV TUTORIAL 4 - 2.2- VARIAVEIS ESCOPO - PARTE 2
DICAS 2982 - WINDEV TUTORIAL 5 - 2.1- VARIAVEIS OPERADORES PARTE 3
DICAS 2983 - WINDEV TUTORIAL 6 - 2.1.D - VARIAVEIS STRINGS PARTE 4
DICAS 2984 - WINDEV TUTORIAL 7 - 2.1.E - VARIAVEIS ARRAYS PARTE 5
DICAS 2985 - WINDEV TUTORIAL 8 - 2.2.A - CONDICOES IF-SWITCH PARTE 1
DICAS 2986 - WINDEV TUTORIAL 9 - 2.2.B - CONDICOES PARTE 2
DICAS 2987 - WINDEV TUTORIAL 10 - 2.3.A - LOOP PARTE 1
DICAS 2988 - WINDEV TUTORIAL 11 - 2.3.B - LOOP EXEMPLOS PARTE 2
DICAS 2989 - WINDEV TUTORIAL 12 - Lesson 2.4. The procedures - PARTE 1
DICAS 2990 - WINDEV TUTORIAL 13 - Leçon 2.4.b. Procedures Parametros - PARTE 2
DICAS 2991 - WINDEV TUTORIAL 14 - PROCEDURES REFERENCIA - PARTE 3
DICAS 2992 - WINDEV TUTORIAL 15 - PROCEDURES OPCIONAIS OU OBRIGATORIAS - PARTE 4
DICAS 2993 - WINDEV TUTORIAL 16 - PROCEDURES EXEMPLOS - PARTE 5
DICAS 2994 - WINDEV TUTORIAL 17 - PERGUNTAS E RESPOSTA - PARTE 1
DICAS 2995 - WINDEV TUTORIAL 18 - PERGUNTAS E RESPOSTA - PARTE 2
DICAS 2996 - WINDEV TUTORIAL 19 - WINDEV E OS BANCOS DE DADOS
DICAS 2997 - WINDEV TUTORIAL 20 - PROJETO E ANALISE - CRIACAO
DICAS 2998 - WINDEV TUTORIAL 21 - PROJETO E ANALISE - ARQUIVOS DADOS CLIENTE - PARTE 2
DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3
DICAS 3000 - WINDEV TUTORIAL 23 - PROJETO E ANALISE - IMPORTANDO CVS-ARQUIVO TEXTO - PARTE 4
DICAS 3001 - WINDEV TUTORIAL 24 - PROJETO E ANALISE - IMPORTANDO ARQUIVO PRODUTO - PARTE 5
DICAS 3002 - WINDEV TUTORIAL 25 - PROJETO E ANALISE - LINK - PARTE 6
DICAS 3003 - WINDEV TUTORIAL 26 - RAD COMPLETO
DICAS 3004 - WINDEV TUTORIAL 27 - VISAO GERAL
DICAS 3005 - WINDEV TUTORIAL 28 - Adicionar e Modificar Janelas PRODUTOS - PARTE A
DICAS 3006 - WINDEV TUTORIAL 29 - Adicionar e Modificar Janelas PRODUTOS Formulario - PARTE B
DICAS 3007 - WINDEV TUTORIAL 30 - Adicionar e Modificar Janelas PRODUTOS ALINHAR CAMPOS - PARTE C
Nenhum comentário:
Postar um comentário