quarta-feira, 26 de agosto de 2020

DICAS 3052 - WINDEV TUTORIAL 75 - HYPERFILE - CONFIGURANDO SERVIDOR - PARTE B - 03-09-2020 14Hrs




https://youtu.be/JoW3yEJPWSU


Bom Dia/Boa Tarde/Boa Noite

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

DICAS 3052 - WINDEV TUTORIAL 75 - HYPERFILE - CONFIGURANDO SERVIDOR - PARTE B - 03-09-2020 14Hrs
Tutoriel WINDEV : Leçon 5.2. HFSQL Client/Serveur - Mise en place d'une base Client Serveur

ASSUNTOS

ENTRANDO NO PROGRAMA DE EXERCICIO
ENTRANDO NA ANALISE
CRIAR UMA NOVA CONEXAO
CONEXAO_TUTORIAL
DIZER QUE QUER TRANSFORMAR DE CLASSI PARA HYPER FILE
DIZER QUE QUER CONVERTER A BASE 
ENTRANDO NO CONTROL CENTER PARA VER SE ESTA LA OS DADOS
APARECEU OS DADOS, MUITO TOP



Video original da Franca

https://youtu.be/dJLOCmC6X8k


Playlist Windev TUTORIAL

PlayList Hyperfile

https://youtu.be/3DshsXJ8I2M



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
























Lesson 5.2. Implementing a Client/Server database
This lesson will teach you the following concepts
  • Installing a local HFSQL server.
  • Creating an application that uses an HFSQL Client/Server database.
  • Adapting an application to manage an HFSQL Client/Server database.
  • Features available in Client/Server mode.
Lesson duration

Estimated time: 10 mn
Previous LessonTable of contentsNext Lesson
Overview
In this lesson, we are going to perform all operations required to develop and to deploy an application that uses an HFSQL Client/Server database.
Installing a local HFSQL server
The first operation to perform consists in installing an HFSQL server.
This server can be installed locally on the development computer (that's what we are going to do). In deployment, this server can be installed on a specific computer.
The HFSQL server setup program is available on the WINDEV setup media. If you do not have this media, the HFSQL server setup is also available on our site (www.windev.com).
To install the HFSQL server locally:
  1. Start the WINDEV setup program.
  2. Select "HFSQL Server Setup".
  3. Then, select "Install or update an HFSQL server".
  4. Accept the license agreement.
  5. Choose the platform ("For Windows on this computer").
  6. If HFSQL servers are already installed on the current computer, select "Install a new server".
  7. Select the setup directory and specify the server name and port. The port 4900 will be used by default.

    Remark

    Don't forget to open this port on the firewall in order to connect to the HFSQL server from another computer.
  8. Specify the name and password of the user with management that will be created by default on the HFSQL server. By default, this user is "Admin" and has no password.

    Remark

    For security reasons, don't forget to change the administrator password.
  9. Install the HFSQL Control Center if it is not already present or accessible from your computer.

    Caution!

    The HFSQL Control Center is required to manage the HFSQL Client/Server database.
  10. The wizard proposes to configure the sending of notifications in order to identify the server dysfunctions in real time. In our example, go to the next step and indicate that the setting will be performed "Later".
  11. The wizard proposes to enable the authentication via Active Directory. Enable this option if necessary.
  12. Validate (or not) the participation in product improvement by allowing us to collect information regarding the use of product. This optional and anonymous collect allows PC SOFT to improve the product features.
  13. The setup is performed. By default (if you have not changed the administrator settings), to connect to the server in administrator mode, you must use the "Admin" user without a password.
Creating an application that uses an HFSQL Client/Server database
Creating a WINDEV application that uses an HFSQL Client/Server database is child's play. You must:
  1. Create the project by asking to create a new database.
  2. Create the analysis by specifying that the databases used by the project will be "HFSQL Client/Server" databases.
  3. Specify the characteristics of the connection to the HFSQL Client/Server server that will be used.
  4. When creating a data file in the analysis, indicate that this data file is in Client/Server mode and specify the connection used.

Remark

You can also describe the connection to the HFSQL server by programming. See the online help for more details: HDescribeConnection.
Adapting an application to use an HFSQL Client/Server database

Overview

Switching a database from HFSQL Classic mode to Client/Server mode is the most common operation.
WINDEV proposes several methods to perform this switch:
  • perform this adaptation in the data model editor.
  • perform this adaptation from the HFSQL Control Center.
To better understand the different steps, we are going to switch the application created in Part 3 to Client/Server mode using the first method, the data model editor.

Adapting the example

Answer

If you did not perform the operations in the previous lessons, you can follow this lesson by opening a corrected project: in WINDEV's home page (Ctrl + <), click "Tutorial" and select "Full application (Answer)".
  • To adapt the project:
    1. Open the "WD Full Application" project if necessary.
    2. If necessary, go to the "Project explorer" pane and select the "Windows 32-bit executable" project configuration.
    3. Load the analysis of your project in the data model editor: click Opening the data model editor among the quick access buttons. The data model editor is displayed.
    4. On the "Analysis" pane, in the "Connection" group, click "New connection". A wizard is opened, allowing you to create a connection.
    5. Select the type of connection to create: "HFSQL Client/Server".
      Type of connection to create
    6. Go to the next step.
    7. In the following steps, specify:
      Choosing the server
      • the server name (name of your computer for example) and the port number. Go to the next step.
      • the user name and password (leave this information empty to use the administrator). Go to the next step.
      • the database name ("WD Full Application" in our example). Go to the next step.
    8. Type the connection name (keep the proposed name).
    9. Go to the next step and validate. The connection to the database is automatically created. The wizard proposes to associate the different data files found in the analysis with the connection that was just created.
      Associating files with the connection
    10. Click "Yes".
    11. In the next step, select all the data files proposed:
      Choosing the data files
      Go to the next step.
    12. Then, the wizard proposes to copy the data files to the server. Validate ("Copy now").
    13. Select the analysis files that will be copied onto the server: in our case, all data files found in the EXE directory.
      Data files to be associated with the connection
    14. Go to the next step and validate.
    15. The data files in the analysis are automatically changed into HFSQL Client/Server data files and associated with the selected connection.
      Data model editor
    16. Generate the analysis: on the "Analysis" pane, in the "Analysis" group, click "Generation". An automatic modification of data files is automatically proposed. If all the data files are up to date, the automatic modification of data files can be canceled.

      Remark

      Switching to Client/Server mode: tips
      • Check the code of your project: in HFSQL Client/Server mode, the HSubstDir statements, ... are useless.
      • Depending on the parameters specified when creating the connection, the connection defined in the analysis can be modified by HOpenConnection and HChangeConnection.
      • HOpenConnection is used to go back to HFSQL Classic mode: all you have to do is specify the path of directory containing the HFSQL Classic data files.
    17. The development project was successfully adapted. You may also have to adapt the deployed application (if the deployed application uses HFSQL Classic data files for example). This operation is configured when creating the setup program of the application.
Features available in HFSQL Client/Server mode
HFSQL Client/Server proposes several features:
These features will not be described here (some of them have been presented in this tutorial in HFSQL Classic mode).

Teste

Teste
teste