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.
This object can be created in objects: PmaRoot, PmaFolder, PmaPrototype. Multiple objects of this type can be created in such objects.
The usage of the PmaAdo object requires purchase of the "PmDB" licence. With the freeware version PmFree, or when developing the application (with development environment for tersting purposes), this component is always functional.
| 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 |
| 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 method of the object |
| 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 |
If you enter the parameter "return:map;", then the methods return moredetailed information regarding the results of method callings.