PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • How to proceed?
  • Automatic mode
  • Manual mode
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
An application that is using the user groupware can be used with a HFSQL database in Client/Server mode.
In order for an application that is using the user groupware to operate in Client/Server mode, you must:
  • convert the existing application into Client/Server mode. See Client/Server for more details.
  • configure the user groupware in order to use the data files found on the server. These operations are presented in this help page.
How to proceed?

Automatic mode

To convert the data files of user groupware into Client/Server mode:
  1. On the "Project" pane, in the "Project" group, click "User groupware".
  2. In the "Files" tab, select "HFSQL Client/Server".
  3. Specify:
    • the name of the server used.
    • the port number used.
    • the user name used for the database.
    • the associated password.
    • the name of the database.
    • the directories of data files.
  4. If the data files specific to the user groupware exist, copy these data files onto the server.

Manual mode

To convert the data files of user groupware into Client/Server mode:
  1. On the "Project" pane, in the "Project" group, click "User groupware".
  2. In the "Execution" tab, select "Manual run".
    The user groupware must not be started in "Automatic run" mode in your application.
  3. Select the different options of the user groupware and validate the window.
  4. In the initialization code of the project, use gpwOpenConnection to describe the connection to the HFSQL Client/Server database.
  5. If the data files specific to the user groupware exist, copy these data files onto the server.
  6. Use gpwOpen to specify the positioning of data files. The specified directory must be relative to the server directory.
Related Examples:
WD CSGroupware Training (WINDEV): WD CSGroupware
[ + ] This example presents the use of the user groupware on a HFSQL Client/Server database.
The user groupware:
The user groupware allows you to define different access levels to an application according to the rights granted to each user. By default, all the rights are granted to the SUPERVISOR group. You have the ability to define groups of users and to configure the available options for each group. For example, all the deletion buttons will be invisible for the "Trainee" group.
The implementation of the user groupware in Client/Server mode is used to centralize the data files on the server (files of your application and files specific to the user groupware).
The example:
When starting the application, you must specify the information for connecting to the Client/Server database. The specified database will be created if it does not exist. Then, the user groupware will ask you to identify yourself.
Two users are proposed:
- SUPERVISOR (password: supervisor)
- USER1 (password: user1)
These two users can access different options of the application.
Minimum required version
  • Version 18
This page is also available for…
Comments
Groupware operation with the native driver of the MS SQL Server
ConexaoGpw is Connection

IF NOT gpwOpenConnection(conexaoGpw, ConfiguracoesBancoDados.NomeUsuarioBD, ConfiguracoesBancoDados.SenhaBanco, ConfiguracoesBancoDados.NomeServidor, ConfiguracoesBancoDados.NomeBancoDados, hAccessHFClientServer, hOReadWrite) THEN

Info("Falha na Conexão com o Grupo de Usuários"+CR+HErrorInfo())

EndProgram()

END
adrianoboller
Apr. 16 2016