quinta-feira, 27 de agosto de 2020

DICAS 3054 - WINDEV TUTORIAL 77 -03-09-2020 18Hrs- HYPERFILE INSTALANDO EM CLIENTE - PARTE D -



https://youtu.be/ijVt5lURaj4




Bom Dia/Boa Tarde/Boa Noite

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

DICAS 3054 - WINDEV TUTORIAL 77 -03-09-2020 18Hrs- HYPERFILE INSTALANDO EM CLIENTE - PARTE D - 
Tutoriel WINDEV : Leçon 5.4. HFSQL Client/Serveur - Installation en clientèle


ASSUNTOS

APRESENTACAO
VISAO GERAL
INICIANDO O ASSISTENTE PARA CRIACAO DE CONFIGURACAO
ADICIONANDO AS INFORMACOES DOS DADOS - O QUE LEVAR
ADICIONANDO WINDOWS OU LINUX
ADICIONANDO PROGRAMAS ADICIONAIS
ADICIONAR CONEXAO
MOSTRANDO INSTALADOR



Video original da Franca

https://youtu.be/QcQsEhQwhTE


Playlist Windev TUTORIAL

PlayList Hyperfile





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.4. Setup on end-user computers
This lesson will teach you the following concepts
  • How to install a Client/Server application on the user computers?
Lesson duration

Estimated time: 5 mn
Previous LessonTable of contentsNext Lesson
Overview
Installing a Client/Server application requires several specific options. These options are taken into account by the wizard for setup creation of WINDEV.
We are going to create the setup procedure of our "WD Full Application" application.
Starting the wizard for setup creation
To start the setup procedure of an HFSQL Client/Server application:
  1. On the "Project" pane, in the "Generation" group, click "Setup procedure".
  2. Create the executable and validate the help creation.

    Express

    Creating a hep system is not available in Express version.
  3. Click the "Data" option on the left side of wizard: the "Parameters of the databases" step is displayed. In this step, you can:
    • Include the setup of an HFSQL server,
    • Configure the location of the application data files,
    • Deploy the data files on an HFSQL server.

      Express

      Some options are not available in the Express version.
      Creating the setup
    If these options are checked, the next steps are used to configure the elements that will be taken into account for the setup on end-user computers.
See Setup: Parameters of databases for more details.

DICAS 3053 - WINDEV TUTORIAL 76 - HYPERFILE GERENCIANDO SERVIDOR - PARTE C - 03-09-2020 16Hrs



https://youtu.be/3_6FkPGy8dw






Bom Dia/Boa Tarde/Boa Noite

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

DICAS 3053 - WINDEV TUTORIAL 76 - HYPERFILE GERENCIANDO SERVIDOR - PARTE C - 03-09-2020 16Hrs

ASSUNTOS

O QUE VAMOS APRENDER 
APRESENTACAO 
CONFIGURACAO DA ESTACAO DE TRABALHO
O CENTRO DE CONTROLE HFSQL
ENTRANDO CONTROLE ATRAVEZ DO WINDEV 
ENTRANDO NA TABELA CLIENTE E FAZENDO CONEXAO
ENTRANDO NA TABELA PEDIDO E MOSTRANDO PROPRIEDADES
CRIAR UMA CONTA DE USUARIO NO HFSQL 
COMO ENTRAR NO CONTROL CENTER 
CRIADO O USUARIO E EXPLICADO ALGUMAS OPCOES
DAR DIREITO DE CONECTAR AO BANCO DE DADOS 
DAR DIREITO SOBRE UMA TABELA NO CASO CLIENTE 
ENTRANDO NO USUARIO TESTE 
MOSTRANDO BACKUP
DANDO OPINIAO




Video original da Franca

https://youtu.be/iuMiIxXze3Q


Playlist Windev TUTORIAL

PlayList Hyperfile

https://windevdesenvolvimento.blogspot.com/2020/01/dicas-2617-windev-webdev-mobile.html




https://youtu.be/3DshsXJ8I2M

https://youtu.be/EqnYJFpvPAI








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.3. Managing a Client/Server database
This lesson will teach you the following concepts
  • The HFSQL Control Center.
  • Creating a user in the HFSQL Control Center.
  • Saving the database.
Lesson duration

Estimated time: 20 mn
Previous LessonTable of contentsNext Lesson
Overview
Now that we know how to create and/or adapt an application so that it operates in HFSQL Client/Server, let's see how to manage the associated database.
Indeed, a Client/Server database requires:
  • a specific configuration of computers (setup of an HFSQL server, etc.).
  • a management performed via the HFSQL Control Center.
Configuring the computers
To use an HFSQL Client/Server database, an HFSQL server must be installed on the server. Several HFSQL servers that use different ports can be installed on the same computer. One or more databases can be installed on each server.
For example, a test HFSQL server, with a test database and a production HFSQL server that use a different port, can be installed on the same computer.
The HFSQL Control Center
The HFSQL Control Center is used to perform all management operations on the HFSQL Client/Server servers and databases.
We are going to present the most important features.
First of all, we are going to start the HFSQL Control Center from the WINDEV project.
  • To start the HFSQL Control Center and to access data:
    1. In the WINDEV menu, on the "Tools" pane, in the "Database" group, click "HFSQL". The HFSQL Control Center is displayed.
    2. The home window of HFSQL Control Center is displayed. The analysis of current project is automatically selected.
      Home window
    3. Validate the screen. The HFSQL Control Center is displayed. This mode allows you to see the different files linked to the analysis of the current project.
    4. Click the vertical tab named "HFSQL C/S" if necessary. The list of data files in HFSQL Client/Server format is displayed.
      List of data files
      The Control Center lists the Client/Server data files found in the analysis linked to the current project. No connection is established: the data files appeared grayed.
    5. To see the data found in the files, double-click one of the data files in the list on the left ("Orders" for example). If the HFSQL Control Center does not recognize all connection parameters, a connection window is used to perform the effective connection to the HFSQL Client/Server server used. If this window is displayed, specify the password and validate.
    6. The information about the selected data file that uses this connection is displayed in a new "Orders" pane. This pane presents this information in several vertical tabs:
      Information on the data file
      • The "Description" tab gives information about the data files (data file items, etc.).
      • The "Content" tab displays the records found in the data files.
The entire HFSQL Client/Server database can be managed from the HFSQL Control Center.
Creating a user account in the HFSQL Control Center
A single user account is created when installing an HFSQL server and when creating a database: the administrator account ("Admin" login without password).
Using a user account allows you to secure the access to data. Indeed, all application users are not administrators. Specific rights can be granted to each user (or group of users).

Caution!

The user rights specified in the HFSQL Control Center are granted for the database (and not for the application).
Do not confuse the management of rights for the Client/Server databases with the user groupware.
Some users may not have the rights to write into some data files for example.
To run a simple test, we are going to create a user and allow this user to see the records in the Customer data file.
  • To directly connect to the database found on the server:
    1. Expand the Control Center menu menu at the top left of the HFSQL Control Center and select "Connect to an HFSQL server".
    2. The home window of HFSQL Control Center is displayed.
      Home window
    3. The option "Connect to an HFSQL server" is selected by default. Specify the characteristics of the server that was installed in the previous lesson and validate.
    4. The characteristics of HFSQL server are displayed:
      • the name of HFSQL server as well as the list of databases found on this server are displayed in the left panel.
      • in the right section of the screen, a new tab allows you to see the characteristics of HFSQL server.
        HFSQL Server characteristics
    5. In the right section of the screen, select the "Users" tab. This tab is used to manage the server users.
    6. Only the "Admin" user exists at this time.
      Management of users
    7. To create a new user, in the ribbon, in the "Users" group, click the "New" button. The window used to define the user characteristics is displayed.
    8. Type the following information:
      Properties of a user
      (use "Test" as password for example).

      Remark

      Several characteristics can be noticed:
      • Super User: The users defined as "Super user" are allowed to perform all types of actions on the server, on the databases and on all the data files.
      • Account enabled: If this option is not checked, the user exists but he is not enabled (users on holiday for example).
      • Password expiration: You can specify a password valid for a limited number of days. (configurable).
    9. Validate the user creation. By default, no rights are granted to this user.
We are now going to grant rights to the user: the "Test" user can connect to the database and read the Customer data file.
  • To grant rights to connect to the database:
    1. In the HFSQL Control Center, double-click the "WD Full Application" database.
    2. On the "WD Full Application" pane, in the "Rights" group, click "Management of rights".
    3. Select the "Test" user in the list of users.
    4. In the list of rights, for the action named "Rights to connect to the server (encrypted and unencrypted connection)", click in the "Defined rights" column and select the green checkmark.
      Rights of a user on the database
    5. Click "Apply" at the bottom of window. The rights become effective.
    6. Close the window for managing rights.
  • To grant rights to read the Customer data file:
    1. In the HFSQL Control Center, expand the "WD Full Application" database and double-click the Customer data file (on the left of the screen).
    2. On the "Customer" pane, in the "Rights" group, click "Management of rights".
    3. Select the "Test" user in the list of users.
    4. In the list of rights, for the action named "Rights to read the records of a file", click the "Defined rights" column and select the green checkmark.
      Rights of a user on a data file
    5. Click "Apply" at the bottom of window. The rights become effective.
    6. Close the window for managing rights.
Similarly, rights can be defined:
  • on the HFSQL server
  • on the database
  • on the database files.
In our example, the "Test" user can only browse the records in the Customer data file. If this user tries to perform another action, a message will be displayed: "The Test user has no sufficient rights to XXXX" (where XXXX corresponds to the action performed).
Once the account is created, it can be used when the application connects to the server (when HOpenConnection is used).

Remark

The users and their rights can also be managed by programming with the WLanguage functions.
See Functions for HFSQL Client/Server management for more details.
Make a backup copy of the database
To make a backup copy of the database:
  1. Go to the tab corresponding to the "WD Full Application" database.
  2. Select the vertical tab named "Backups".
  3. In the menu, in the "Backups" group, expand "New backup" and select "New hot backup".
    Remark: This button is accessible in the "Backups" group:
    • on the tab corresponding to the HFSQL server,
    • on the tab corresponding to the database.
      Remark: The wizard can also be used to save a selection of data files.
  4. Validate the backup.
Conclusion
The HFSQL Control Center is a tool for managing databases, allowing you to:
  • stop or restart a server if a problem occurs,
  • manage the users and their rights,
  • reindex the data files if necessary,
  • perform database backups.
The HFSQL Control Center is a redistributable tool that can be installed on the computers of users who are working with HFSQL Client/Server databases. The HFSQL Control Center must be used by the database administrator.


Teste

Teste
teste