<Connection variable>.OpenConnection (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

Syntax 1: Open a predefined connection: automatic connection management

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.OpenConnection (Function)

In french: <Variable Connexion>.OuvreConnexion

Not available with this kind of connection

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.

Example

MyConnection is Connection 
// Describe the connection 
MyConnection.User = "USER" 
MyConnection.Password = "PASSWORD" 
MyConnection.Server = "MYSERVER" 
MyConnection.Database = "Database" 
MyConnection.Provider = hAccessHFClientServer 
MyConnection.Access = hOReadWrite 
MyConnection.ExtendedInfo = "Extended information" 
MyConnection.CursorOptions = hClientCursor 

MyConnection.OpenConnection()

Syntax

<Result> = <Connection>.OpenConnection()

<Result>: Boolean

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>: Connection variable

Name of the Connection variable that describes the connection to a database.

Remarks

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.

Component: wd300hf.dll