AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Syntax 1: Opening a preset connection: automatic management of connections
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Otros
Procedimientos almacenados
Opens a connection to a specific database. The connection remains opened until the call to <Variable Connection>.CloseConnection. <Variable Connection>.OpenConnection is used to open a connection defined with a Connection variable. Caution: The order in which the functions for connecting to an HFSQL Client/Server database are called is important. For more details, see Optimizing the connection times to the HFSQL Client/Server databases.
Ejemplo
WindowsLinuxAjaxHFSQL ClassicHFSQL Client/ServerOLE DBConectores Nativos
MaConnexion is Connection 
// Description de la connexion
MaConnexion.Utilisateur = "USER" 
MaConnexion.MotDePasse = "PASSWORD" 
MaConnexion.Serveur = "MONSERVEUR" 
MaConnexion.BaseDeDonnées = "Base de données" 
MaConnexion.Provider = hAccessHFClientServer 
MaConnexion.Accès = hOReadWrite 
MaConnexion.InfosEtendues = "Infos étendues" 
MaConnexion.OptionsCurseur = hClientCursor 

MaConnexion.OuvreConnexion()
Sintaxis
<Result> = <Connection>.OpenConnection()
<Result>: Booleano
  • True if the operation was performed,
  • False if a problem occurred (during a connection described through programming, some parameters used in HDescribeConnection may be incorrect for example).
HErrorInfo is used to identify the error.
<Connection>: Variable de tipo Connection
Name of the Connection variable that describes the connection to a database.
Observaciones
WEBDEV - Código ServidorPHPAjaxHFSQL ClassicHFSQL Client/ServerOLE DBConectores Nativos

Syntax 1: Opening a preset connection: automatic management of connections

  • The connection associated with a data file is automatically opened when the data file is opened. The connection is closed when the last data file that uses this connection is closed.
  • Any connection opened by <Variable Connection>.OpenConnection remains open even if no data file uses it.
  • If the application opens and closes data files many times in a row, the automatic management of connections will open/close connections many times, slowing down the application. In this case, it is recommended to use <Variable Connection>.OpenConnection to keep the connection open.
Componente: wd290hf.dll
Versión mínima requerida
  • Versión 25
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 20/06/2023

Señalar un error o enviar una sugerencia | Ayuda local