Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Object PmAdo (ADO database)

Description:
See: PmAdo - Deatiled object description
 
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 PmAdo object can be used for read/write the data from/to the physical database table and also can execute SQL commands in he connected database.

The PmAdo object directly enables the objects and methods of the ADO technology. Especially the AdoRecordset object as a result of the SQL command 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 the PmRoot, PmFolder and PmPrototype objects. Multiple objects of this type can be created in such objects.
 
No other PROMOTIC objects can be created in this object.

The PmAdo object is bound on the 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 PmObject
Properties and methods:
DbBeginTrans Starts new transaction over the connected database
DbClose Disconnection of the PmAdo object of the database and release of all stored AdoRecordset objects
DbCommitTrans Confirms transaction over connected database
DbConnectionParams Additional dtabase connection parameters
DbConnectionString Database connection parameters
DbExecute Executes the command entered in the syntax of the SQL language
DbIsOpen Testing the databese connection of the PmAdo object
DbOpen Connecting the PmAdo object to the database
DbRollbackTrans Cancells transaction over connected database
LastErr The numeric error code of the result of last executed method (property) over the PmAdo object
LastTextErr The text description of the result of last executed method (property) over the PmAdo 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 Testing 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
Main Basic setup for database access via the ADO
Methods Definition of user's methods of the object
List of subobjects:
AdoField(ADO Field) The ADO Field object contains the column information
AdoRecord(ADO Record) The ADO Record object represents a single record
AdoRecordset(ADO Recordset) The ADO Recordset object represents a set of records
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice