PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • How to use the gpwOpen function?
  • Pre-launched sessions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
gpwOpen (Function)
In french: gpwOuvre
AjaxNot available
ODBCOLE DBNot available with these kinds of connection
Opens the login window or page of user groupware.
Remark: This function is required only if the user groupware was integrated with the "Manual run" option. If the option "Automatic start" has been selected, this function is ignored.
Example
// Ouvre la fenêtre de login du groupware utilisateur
nRes is int = gpwOpen("c:\GpwUtilisateur")
// Si le login a échoué
IF nRes <> gpwOk THEN
SWITCH nRes
CASE gpwCancel: Info("Vous avez cliqué sur le bouton Annuler.")
CASE gpwError: Error("Erreur à l'initialisation du groupware.")
CASE gpwUnknownUser: Error("Utilisateur inconnu.")
CASE gpwInvalidPassword: Error("Mot de passe invalide.")
END
EndProgram()
END
// Récupération du prénom de l'utilisateur
Prénom is string = gpwGetUserInfo(gpwInfoFirstName)
Info("Bienvenue" + Prénom)
Syntax
Versions 18 and later
WEBDEV - Server code

Syntax of new user groupware Hide the details

<Result> = gpwOpen([<Directory of groupware files>])
<Result>: Integer constant
Result regarding the opening of login window/page.
gpwCancelThe user clicked the "Cancel" button found in the login window of Groupware.
gpwErrorAn error occurred. For more details, use ErrorInfo.
gpwInvalidPasswordThe password is not valid. It does not correspond to the user password described in the groupware database.
gpwOkThe user is connected.
gpwUnknownUserThe user is not referenced in the database of user groupware.
<Directory of groupware files>: Optional character string
These data files are used to manage the users and their rights. By default, these data files are created in a subdirectory of your project (EXE\GPW_<Project name> directory).
HFSQL Client/Server By default, these data files are created on the server in a subdirectory of your database: directory .\GPW_<Project name>.

If this parameter corresponds to an empty string ("") or if it is not specified, the default directory of the user groupware will be used.
HFSQL Client/Server If this parameter corresponds to a dot ("."), the data files of user groupware will be created on the server at the root of database.
New in version 18
WEBDEV - Server code

Syntax of new user groupware Hide the details

<Result> = gpwOpen([<Directory of groupware files>])
<Result>: Integer constant
Result regarding the opening of login window/page.
gpwCancelThe user clicked the "Cancel" button found in the login window of Groupware.
gpwErrorAn error occurred. For more details, use ErrorInfo.
gpwInvalidPasswordThe password is not valid. It does not correspond to the user password described in the groupware database.
gpwOkThe user is connected.
gpwUnknownUserThe user is not referenced in the database of user groupware.
<Directory of groupware files>: Optional character string
These data files are used to manage the users and their rights. By default, these data files are created in a subdirectory of your project (EXE\GPW_<Project name> directory).
HFSQL Client/Server By default, these data files are created on the server in a subdirectory of your database: directory .\GPW_<Project name>.

If this parameter corresponds to an empty string ("") or if it is not specified, the default directory of the user groupware will be used.
HFSQL Client/Server If this parameter corresponds to a dot ("."), the data files of user groupware will be created on the server at the root of database.
WEBDEV - Server code

Syntax of new user groupware Hide the details

<Result> = gpwOpen([<Directory of groupware files>])
<Result>: Integer constant
Result regarding the opening of login window/page.
gpwCancelThe user clicked the "Cancel" button found in the login window of Groupware.
gpwErrorAn error occurred. For more details, use ErrorInfo.
gpwInvalidPasswordThe password is not valid. It does not correspond to the user password described in the groupware database.
gpwOkThe user is connected.
gpwUnknownUserThe user is not referenced in the database of user groupware.
<Directory of groupware files>: Optional character string
These data files are used to manage the users and their rights. By default, these data files are created in a subdirectory of your project (EXE\GPW_<Project name> directory).
HFSQL Client/Server By default, these data files are created on the server in a subdirectory of your database: directory .\GPW_<Project name>.

If this parameter corresponds to an empty string ("") or if it is not specified, the default directory of the user groupware will be used.
HFSQL Client/Server If this parameter corresponds to a dot ("."), the data files of user groupware will be created on the server at the root of database.
WEBDEV - Server code

Syntax of the former user groupware (kept for backward compatibility) Hide the details

<Result> = gpwOpen([<Directory of rights file> [, <Directory of user files>]])
<Result>: Integer constant
Result regarding the opening of login window/page.
gpwCancelThe user clicked the "Cancel" button found in the login window of Groupware.
gpwErrorAn error occurred. For more details, use ErrorInfo.
gpwInvalidPasswordThe password is not valid. It does not correspond to the user password described in the groupware database.
gpwOkThe user is connected.
gpwUnknownUserThe user is not referenced in the database of user groupware.
<Directory of rights file>: Optional character string
These data files are used to manage the rights granted to the users for the different windows of the application. These files are specific to the application. By default, these data files are created in a subdirectory of your project (EXE\GPW_<Project name> directory).
HFSQL Client/Server By default, these data files are created on the server in a subdirectory of your database: directory .\GPW_<Project name>.

If this parameter corresponds to an empty string ("") or if it is not specified, the default directory of the user groupware will be used.
HFSQL Client/Server If this parameter corresponds to a dot ("."), the data files of user groupware will be created on the server at the root of database.
<Directory of user files>: Optional character string
These data files can be common to several applications. By default, these data files are created in a subdirectory of your project (EXE\GPW_<Project name> directory). You can define the location of the user groupware files common to several applications. In this case, you must specify the path of data files to use.
HFSQL Client/Server By default, these data files are created on the server in a subdirectory of your database: directory .\GPW_<Project name>.

If this parameter corresponds to an empty string ("") or if it is not specified, the default directory of the user groupware will be used.
HFSQL Client/Server If this parameter corresponds to a dot ("."), the data files of user groupware will be created on the server at the root of database.
Remarks

How to use the gpwOpen function?

gpwOpen is used to customize the start mode of user groupware. This allows you to run lines of code, to open windows or pages, ... before opening the connection window or page of user groupware.
Usage example of this function: in a multilingual application that is using the user groupware, the first window or page of the application is used to choose the runtime language. When creating the application, you must:
  • choose not to automatically run the user groupware during its integration
  • open the window or page for language selection as first application window, then call the login window or page with gpwOpen.
Versions 20 and later

Pre-launched sessions

If your project uses pre-launched sessions, this function must not be used in the "Initializing" event of the project. This function must be used in the event "Initializing the project after connection to the site".
New in version 20

Pre-launched sessions

If your project uses pre-launched sessions, this function must not be used in the "Initializing" event of the project. This function must be used in the event "Initializing the project after connection to the site".

Pre-launched sessions

If your project uses pre-launched sessions, this function must not be used in the "Initializing" event of the project. This function must be used in the event "Initializing the project after connection to the site".
Business / UI classification: Neutral code
Component: wd270gpu.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Exemplo de uso do comando gpwOpen()
//Conexao
ok, ok1, ok2, ok3 is boolean

myConn is Connection
myConn..Provider = hNativeAccessSQLServer
myConn..User = "adriano"
myConn..Password = "adriano@2016"
myConn..Source = "192.168.0.162\projeto01"
myConn..Database = "projeto01"
myConn..Access = hOReadWrite

ok1 = HOpenConnection(myConn)
IF ok1 = False THEN
Info(ErrorOccurred() +" - "+ HErrorInfo())
END


IF gpwInitAnalysis() = False THEN
Error(ErrorInfo())
ok2 = False
ELSE

ok2 = True
IF gpwOpen() = gpwOk
ok3 = True
ELSE
Info(ErrorOccurred() +" - "+ HErrorInfo())
ok3 = False
END

END

NextTitle("Atenção")

IF ok1 = True AND ok2 = True AND ok3 = True THEN //deve dar tudo ok

Info("Conectou com sucesso no banco de dados!")

ELSE

Info("Falha ao tentar conectar no Servidor")

END
BOLLER
28 Nov. 2016