Connect - method of object PmDatabase

Description:

It is used for the connection of the database defined by the Type and Database properties to the application. A query to the data of the table, possible a SQL statement, defined by the Table property, possible by the OpenSQL property, isn't proceeded (the table hasn't been opened yet).

Syntax:

Connect As Boolean

Calling:

oDb.Connect

Note:

The method doesn't open the table of the database.

After calling this method, the Execute and ExecuteSQL methods can be called, the other methods of this object can't be called (only after opening the table for example by the Open method).

The operation is understood as the connection of the database when the application is connected to the database. By this operation an image of the table data (possible the SQL query) isn't created in the storage area of the application - i.e. the table isn't open nor the SQL statement is executed. It corresponds to calling the Connect method.

After connection of the database the Execute/ExecuteSQL methods that are using the SQL language, can be called.

Opening the table means the operation when a set of rows corresponding to the table (possible to the SQL query), is created in the storage area of the application. It corresponds to calling the Open method. On opening the table at fist the database is automatically connected.

Example:

VBScriptSelect and copy to clipboard


Dim oDb
Set oDb = pMe.Pm("/Database0")
Dim sSQL
sSQL = "........"
oDb.Connect

'the database is connected. The Execute/ExecuteSQL methods can be called.
oDb.ExecuteSQL sSQL
'...

'open the table. All other methods can be called.
oDb.Open
'...

'close the table and disconnect the database
oDb.Close