Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Object PmaAdo (ADO database)

Description:
See: PmaAdo - Deatiled object description, PmaAdo - Practical examples
 
This object provides access to databases using the ADO technology. This object represents connection to one database and can contain multiple AdoRecordset objects (providing access to data in physical database tables). The PmaAdo object can be used for read/write the data from/to the physical database table and also can execute SQL statements in he connected database.

The PmaAdo object directly enables the objects and methods of the ADO technology. Especially the AdoRecordset object as a result of the SQL statement SELECT. This technology ensures that the system is as open as possible and averything that can be done using the ADO technology, can also be used in the PROMOTIC system.

 
No other Pma objects can be created in this object.

This object can be created in objects: PmaRoot, PmaFolder, PmaPrototype. Multiple objects of this type can be created in such objects.

Usage of the PmaAdo object requires purchase of the PmDB license. With the freeware version PmFree, or when developing the application (with development environment for tersting purposes), this component is always functional.

This object adopts properties and methods of object PmaObject.
Properties and methods:
DbBeginTrans Starts new transaction over the connected database
DbClose Disconnection of the PmaAdo object of the database and release of all stored AdoRecordset objects
DbCommitTrans Confirms transaction over connected database
DbConnectionParams Additional parameters of database connection
DbConnectionString Database connection parameters
DbExecute Executes the statement entered in the syntax of the SQL language
DbIsOpen Test whether the PmaAdo object has the database connection
DbOpen Connecting the PmaAdo object to the database
DbRollbackTrans Cancells transaction over connected database
LastErr The numeric error code of the result of the last executed method (property) of the PmaAdo object
LastTextErr The text description of the last executed method (property) of the PmaAdo object
RsClose Releases the stored AdoRecordset object with defined identifier
RsGet Opens up the stored AdoRecordset object with defined identifier, that has been created previously by calling the RsOpen method
RsIsOpen Test of the existence of the AdoRecordset object with defined identifier
RsOpen Executes the SQL query SELECT, and provides the resulting data in the form of AdoRecordset
Configuration windows:
Object General information about the object
Content Content of the object in the XML form
Events Definition of object events algorithms
ADO Basic settings for database access via the ADO
Methods Definition of designer's methods of the object
Related objects:
AdoField(ADO Field) Object ADO Field contains the column information
AdoRecord(ADO Record) Object ADO Record represents a single record
AdoRecordset(ADO Recordset) Object ADO Recordset represents a set of records

History:
Pm9.00.00: Object name changed: PmAdo -> PmaAdo
Pm8.03.22: Generalization of methods DbOpen, DbExecute, RsOpen, DbBeginTrans, DbCommitTrans, DbRollbackTrans.

If you enter the parameter "return:map;", then the methods return moredetailed information regarding the results of method callings.

Pm8.03.09: new methods for transactions support: DbBeginTrans, DbCommitTrans and DbRollbackTrans.
Pm8.01.03: Some methods of the Microsoft objects AdoRecordset did not return the confirmation of completion/failure. Therefore the Promotic system adds properties (Pm_LastErr and Pm_LastTextErr) into this object, that can be used for obtaining such confirmation.
Pm8.01.00: This object allows to access databases via the ADO technology. The object is more general and developed compared to the PmaDatabase object (that supported DAO and ODBC technologies) and therefore it is recommended to to use the PmaAdo object for database access.
PROMOTIC 9.0.7 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice