<Connection variable>.OpenConnection (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

ErrorStatusModification

FilterIncludedBetween

MigrateLinkedCompositeKey

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

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 in which the functions for connecting to an HFSQL Client/Server database are called is important. See Optimizing the connection times to the HFSQL Client/Server databases for more details.

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 by 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: 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 <Connection variable>.OpenConnection remains opened even if it is not used.
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, we recommend that you use <Connection variable>.OpenConnection to keep the connection opened.

Component : wd260hf.dll