Examples of using Pmado in English and their translations into Czech
{-}
-
Colloquial
-
Official
Testing if the PmAdo object("/TestAdoDb") is connected to the database.
The failure of the operation can be detected in PmAdo object by LastErr property.
The PmAdo object directly enables the objects and methods of the ADO technology.
DBase database server- connecting to database by PmAdo object and table usage.
New object PmAdo: this object allows to access databases via the ADO technology.
People also translate
This object is obsolete(but functional) andit is much better to use the PmAdo object.
Disconnection of the PmAdo object of the database and release of all stored AdoRecordset objects.
The sequence of operations while reading the data into the PROMOTIC application by the PmAdo object.
The PmAdo object may simultaneously contain multiple SQL query results in the form of AdoRecordset objects.
The numeric error code of the result of last executed method(property) over the PmAdo object.
This is different for access to user data( PmAdo, PmDatabase), where the database must exist or must be created by script.
Releasing the stored AdoRecordset object with unique identifier("table1") from the PmAdo object"/TestAdoDb.
See: Object PmAdo, PmAdo- Practical examples The PmAdo object contains a single database connection ADO Connection.
After this preconfiguration is created, the configurator is se to: PmAdo> Main> Database connection parameters.
Reading the data over the PmAdo object("/TestAdoDb"), that is already connected to the database(see DbOpen), using the SQL query"SELECT* FROM table1.
The application can work with this data via the ODBC interface(registered data ODBC source'pm_data')using the PmAdo and PmDatabase objects.
PmAdo- here the designer must ensure that some MySQL server query is activated at least once in a defined timeout period or more often.
Re-reading of existing data in the AdoRecordset object,previously created and stored in the PmAdo object("/TestAdoDb") with defined identifier"table1.
MySQL server- connecting to database by PmAdo object and table usage.: Preconfigurations- MySQL server- connecting to database by PmAdo object and table usage.
The object is more general and developed compared to the PmDatabase object(that supported DAO and ODBC technologies) andtherefore it is recommended to use the PmAdo object for database access.
The'pm_data' database: is designed for the user data in the PROMOTIC system( PmAdo and PmDatabase objects) and also for PROMOTIC system components data trends, alarms.
Microsoft Access- connecting to database by PmAdo object and table usage.: Preconfigurations- Microsoft Access- connecting to database by PmAdo object and table usage.
Setting the position of the active record to the first record that has in the("name")column the value of("pi"), over the PmAdo object("/TestAdoDb"), that is already connected to the database(see DbOpen), using the SQL query"SELECT* FROM table1.
Compact SQL server- connecting to database by PmAdo object and table usage.: Preconfigurations Compact SQL server- connecting to database by PmAdo object and table usage.
Adding a new record into the table("table1") and modifying the contents of the new record,by using the stored AdoRecordset object("table1"), over the PmAdo object("/TestAdoDb"), that is already connected to the database(see DbOpen), by the SQL query"SELECT* FROM table1.
DBase database server- connecting to database by PmAdo object and table usage.: Preconfigurations- DBase database server- connecting to database by PmAdo object and table usage.
Adding a new record into the table("table1"),by the stored AdoRecordset object("table1"), over the PmAdo object("/TestAdoDb"), that is already connected to the database(see DbOpen), by the SQL query"SELECT* FROM table1.
Reading the data in the form of two dimensional array over the PmAdo object("/TestAdoDb"), that is connected to the database(see DbOpen), using the SQL query"SELECT* FROM table1.
Detects the number of records in the AdoRecordset object, over the PmAdo object("/TestAdoDb"), that is currently connected to the database(see DbOpen), by the SQL query"SELECT* FROM table1.
Setting the first record as the active record position, over the PmAdo object("/TestAdoDb"), that is already connected to the database(see DbOpen), by the SQL query"SELECT* FROM table1.