PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

  • Connection to a blocked database
  • Authorizing the access to a database locked by the HFSQL Control Center
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
<Connection variable>.EndNoDatabaseAccess (Function)
In french: <Variable Connexion>.FinInterditAccèsBaseDeDonnées
HFSQL Client/ServerAvailable only with this kind of connection
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
Remark: Access to the databases had previously been denied using the <Connection variable>.NoDatabaseAccess function.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
Java This function is now available for Java applications.
New in version 22
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
Java This function is now available for Java applications.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
Java This function is now available for Java applications.
Example
// Description de la connexion
MaConnexion est une Connexion
 
SI MaConnexion.InterditAccèsBaseDeDonnées("BaseClient") = Vrai ALORS
// Traitement spécifique
...
MaConnexion.FinInterditAccèsBaseDeDonnées("BaseClient")
FIN
Syntax
<Result> = <Connection>.EndNoDatabaseAccess([<Database>])
<Result>: Boolean
  • True if the access to the specified database (or to all the databases accessed by the connection) is restored,
  • False if an error occurred. HError is used to identify the error.
<Connection>: Connection variable
Name of the Connection variable that describes the connection containing the database to which access must be restored.
<Database>: Optional character string
Name of database for which the access must restored.
If this parameter corresponds to "*", access will be restored for all databases.
If this parameter is not specified, access will be restored for all the databases accessible by <Connection>.
Remarks

Connection to a blocked database

In some cases (power failure for example), the connections to a database may be refused. For example, if a power failure occurs during the execution of this code (before <Connection variable>.NoDatabaseAccess):
// Description de la connexion
MaConnexion est une Connexion
 
// Ouverture de la connexion
MaConnexion.OuvreConnexion()
SI MaConnexion.InterditAccèsBaseDeDonnées("BaseClient") = Vrai ALORS
Info("Il est impossible de se connecter à la base de données")
FIN

To authorize access again, simply establish a connection without specifying a database and use <Connection variable>.EndNoDatabaseAccess.

Authorizing the access to a database locked by the HFSQL Control Center

When the connections to an HFSQL Client/Server database are refused, access can be granted again using HFSQL Control Center. To do so, perform the following operations:
  • Connect as administrator to the server without specifying the database,
  • Display the "Connections" tab of server,
  • In the ribbon, in the "Connections" group, expand the "Lock of connections" button and select "Authorize all the connections".
Component: wd270hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment