AYUDA EN LÍNEA
 WINDEV, WEBDEV Y WINDEV MOBILE
Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Syntax 1: Open a predefined connection: automatic connection management
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
Opens a connection to a specific database. The connection remains opened until the call to <Connection variable>.CloseConnection. <Connection variable>.OpenConnection is used to open a connection defined with a Connection variable. Caution: The order of use of functions for connecting to an HFSQL Client/Server database is important.. For more details, see Optimizing the connection times to the HFSQL Client/Server databases.
Ejemplo
Reportes y ConsultasWindowsHFSQL 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
Reportes y ConsultasHFSQL ClassicHFSQL Client/ServerOLE DBConectores Nativos

Syntax 1: Open a predefined connection: automatic connection management

  • 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 <Connection variable>.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 <Connection variable>.OpenConnection to keep the connection open.
Componente: wd300hf.dll
Ver también
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: 26/09/2024

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