RNVtggtkHaE

Bom Dia/Boa Tarde/Boa Noite

Esse Ao Vivo vai estrear as 16:00 do dia 25/08/2020

DICAS 3017 - WINDEV TUTORIAL 40 - Pesquisa Simples - Pesquisa Identica- PARTE D

Tutoriel WINDEV : Leçon 4.3.d. Recherche simple - Recherche à l'identique

https://windevdesenvolvimento.blogspot.com/2020/08/dicas-3017-windev-tutorial-40-pesquisa.html

https://youtu.be/RNVtggtkHaE

ASSUNTOS

CRIANDO COMBO RELACAO CLIENTE

ALINHANDO COMBO CLIENTE COM OUTROS CAMPOS ABAIXO

CRIANDO BOTAO NO LADO DA COMBO

COMANDOS UTILIZADOS

HReadSeekFirst

HFound

FileToScreen()

https://doc.windev.com/en-US/?1410087533&name=lecon_43_recherche_simple_parcours_des_enregistrements

Video original da Franca

https://youtu.be/rsM9Q78JIgU

Playlist Windev TUTORIAL

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

Exact-match search

To perform an exact-match search, we are going to select the customer name in a Combo Box control. The "Generic search" Button control will be used to display the form of the corresponding person. A single person corresponds to the selected name.

The Combo Box control will be positioned above the created controls. If your controls are placed too close to the top of the Tab control pane, it is necessary to move them down. To do so:
1. Select all the controls in the Tab control pane:
  - Press Ctrl + A: all the controls in the window and in the current pane are selected.
  - Press the Ctrl key.
  - Click the Tab control: only the controls in the Tab control pane are selected.
2. With the mouse, move one of the selected controls to the bottom.
3. All controls are moved to the bottom.

To create the search control:
1. Create a Combo Box control: on the "Creation" pane, in the "Usual controls" group, click on "Combo Box".
2. Click the "Finding customers" pane, between the tab pane and the control "Identifier of Customer".
3. The Combo Box control creation wizard is displayed. We will create a Combo Box control based on the "Customer" data file.
4. Select "Display the data found in a file or in an existing query".
  Go to the next step of the wizard.
5. Select the "Customer" data file. Go to the next step.
6. We are going to display the last and first names of the person.
  - Deselect the "CustomerID" item.
  - Select the "FullName" item.
7. Go to the next step.
8. The "FullName" item will also be used to sort the list of customers displayed in the Combo Box control. Select the "FullName" item.
9. Go to the next step.
10. The value returned by the Combo Box control will be the "CustomerID" identifier. This is the value that will be sought in the Customer data file. Select the "CustomerID" item.
  Go to the next step.
11. The Combo Box control will be linked to no item. Keep "No" and go to the next step.
12. Validate the next step ("Next").
13. Give a name ("COMBO_Customer" for example) and a caption ("Sought customer" for example) to the control.
14. Finish the wizard ("Finish" button). Position the Combo Box control in the window (top left corner for example).
15. Select the Combo Box control and resize it (via the handles) in order for the full customer name to be displayed.

To create the Button control to find customers:
1. Create a Button control: on the "Creation" pane, in the "Usual controls" group, click .
2. Position the Button control beside the Combo Box that was just created.
3. This control is named "BTN_ExactMatchSearch" and its caption is "Exact-match search".
4. If necessary, adjust the size of the control so that the caption is displayed properly in the control.
5. Write the following WLanguage code in the "Click" event of the control:
  // Finds the customer from his identifier
  HReadSeekFirst(Customer, CustomerID, COMBO_Customer)
  IF HFound(Customer) THEN
  // Displays the customer data
  FileToScreen()
  END
6. Let's take a look at this WLanguage code:
  - HReadSeekFirst is used to perform an exact-match search. In this example, the search is performed on the Customer data file and on the CustomerID item. The sought value corresponds to the last parameter of the function. Here, the sought value corresponds to the value selected in the Combo Box. This value is obtained by using the name of the Combo Box control (COMBO_Customer).
  - HFound is used to check the search result. If HFound returns True, a value was found ; if HFound returns False, no value was found. Any record found is read: it becomes the current record in the data file.
  - In this code, if the record was found, it is displayed by FileToScreen.
    Remark
    FileToScreen and ScreenToFile perform the reverse operation: the data found in the file items is displayed in the corresponding controls.
7. Close the code editor.
8. Save the window (Ctrl + S).