Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Connect - method of object PmDatabase

Description:
It serves 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 query, 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 - 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.
See also:
Example:
Dim oDb, sSQL
Set oDb = pMe.Pm("/Database0")
sSQL = "cokoliv"
oDb.Connect
'the database is connected. The Execute/ExecuteSQL methods can be called.
oDb.ExecuteSQL sSQL
...
oDb.Open
'open the table. All other methods can be called.
...
oDb.Close
'close the table and disconnect the database
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice