Database (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage properties / HFSQL properties

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Database (Property)

In french: BaseDeDonnées

Not available with these kinds of connection

The Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.). You can:

Find out the database associated with a connection (HFSQL Client/Server, OLE DB, etc.).
Define the database associated with a connection (HFSQL Client/Server, OLE DB, etc.). In this case, if the connection is currently opened, it will be closed and reopened with the new parameters during the first access to a file that uses this connection.

Remark: The connection can correspond to:

a connection defined in the data model editor,
a connection defined with HConnect, HDescribeConnection or HOpenConnection.
a connection described with a variable of type Connection.

Example

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

HOpenConnection(MyConnection)

Syntax

Finding out the database associated with a connection Hide the details

<Associated database> = <Connection>.Database

<Associated database>: Character string

Database used as data source for the connection.
Empty string ("") if no specific database is associated with the connection.

<Connection>: Name or variable of type Connection

Name of the connection used. This name is defined:
in the data model editor,
with HDescribeConnection or HOpenConnection,
with the Connection type.

Defining the database associated with a connection Hide the details

<Connection>.Database = <New associated database>

<Connection>: Name or variable of type Connection

Name of the connection used. This name is defined:
in the data model editor,
with HDescribeConnection or HOpenConnection,
with the Connection type.

<New associated database>: Character string

Database used as data source for the connection.
Empty string ("") if no specific database is associated with the connection.

Remarks

The CtInitialCatalog property is used to get the default database of a connection. This property is kept for backward compatibility. It is recommended to use the Database property.