Class: cSQLConnectionHandler
See Also: Overview of the DataFlex Database Update Framework
Properties Events Methods
Hierarchy
cObject
---cDbUpdateHandler
------cDbUpdateVersion
------cDbUpdateFunctionLibrary
------cDbUpdateLogFile
------cDbUpdateUserCount
------cSQLConnectionHandler
---------cSQLConnectionIniFile
---------cDbUpdateDatabaseDriver
Library: Windows Application Class Library
Package: cSQLConnectionHandler.pkg
Description
Child class of the cDbUpdateHandler class, but can also be used stand-alone for automatic login to SQL databases. An instance of this class is automatically created by the cDbUpdateHandler class. Thus there is no need to instantiate the class if using the Database Update Framework. It can also be used stand-alone outside the DbUpdateFramework to use SQL connections in a program. Just place an object of the class right after the cApplication object and use the SQLConnections tool to setup your server connection(s).
It is not being used for the embedded database and only when SQLxxx functions of the DbUpdateFunctionLibrary are used.
However, it is mandatory to setup at least one connection with the SQLConnections tool if any of the SQLxxx functions are going to be used or if any contact should be made to an SQL database. It automatically loads the active connection from the SQLConnections.ini file when the Database Update Framework is initialized. Although there are several low level messages for manipulating the login details, all the connection logic is automatically taken care of by the framework.
Internally it uses the cSQLConnectionIniFile class for communicating with the SQLConnections.ini file.
See cDbUpdateHandler for more info about the container object.
Important
If you are using DataFlex 19 or later and have placed a cConnection object inside the cApplication object, those settings will automatically be picked up by the framework. However, since there are more properties that can be set by the SQLConnection tool it might still be a good idea to use it. An alternative is to set those properties in the cDbUpdateHandler object.
Next Topic