Update cookies preferences

Preconfiguration "Asynchronous database access"

connecting to the database by the PmaAdo object and table usage.

This preconfiguration can be activated when creating a new object (e.g. by "New object ..." in the context menu of the object or by pressing the Insert key after selecting the object) and is included in the group: "/ Database access".
This preconfiguration can be created in the object: PmaFolder or PmaRoot.

This preconfiguration in the basic setting creates a PmaFolder object with subobjects PmaSequencer and PmaAdo with preset connection to the selected database. (It will need to be modified in some cases to meet the database connection requirements on the target machine.) Other options create methods for the DtiOper interface in the PmaSequencer object. as well as panels for testing or displaying the table.

The panel is preconfigured in order to allow creation of testing table (datatest) with primary key in the cindex column. The SQL statement for table creation is included in the PmgString object in field DbExecute and is activated by the "Run the SQL statement" button. The INSERT INTO button can be used for adding new record into the database table. The values of new record are generated randomly (in the Values field) by the button with "arrow in a circle" symbol. The buttons UPDATE and DELETE can modify the record or delete it. The button with "arrow in a circle" symbol in this case displays the value that is in the marked row of the table in cindex column. There is an info system in the bottom of the panel that indicates the result of performed operations.

At the beginning of the CallMethod method script of the PmaFolder object examples of calls to the Example1 user method are included in the comments.

These configurators can be set before the preconfiguration is created:
The name of created objectName of the object created in the Pma objects tree.
The maximum name length is 30 characters.
This is a system name, so it must contain only alphanumeric and must not contain any diacritics (i.e. national dependent characters), empty string, spaces and the first character must not be a number.
Default: "DbAsyncAdo"
Type of the database being connected
Microsoft Access
Microsoft SQL Server
Database connection parametersDatabase connection parameters by the DbOpen method in the form of ADO ConnectionString text string. The ADO ConnectionString (http://www.connectionstrings.com) contains all necessary parameters needed by the ADO Connection object for database connection via the selected ADO Provider. The typical parameters are represented for example by connection provider (provider), server address (server), database name (database), login name and password (uid, pwd), etc. The parameter list and exact syntax is defined by the corresponding ADO Provider, parameters may differ by individual ADO Providers. However for the sake of compatibility most providers ADO Provider understand multiple names of the main parameters simultaneously (e.g. the database name can be represented by database, data source, dbq, etc.). Caution: The syntax of this string is different than other strings used in the PROMOTIC system, the value and the name are separated by =, not by "colon" (:). Entries with assigned value are separated by a semicolon, for example "provider=SQLOLEDB;server=.\SQLEXPRESS;database=pm_data;uid=pm_admin;pwd=pmadmin;".
This configurator sets the initial value of the DbConnectionString property.
Macro expression can be used for input (it is evaluated after the application is launched).
Values can be edited manually, or can be created by the button on the right, that opens the window for Database connection parameters (connection string).
The defined parameters may not always be valid (for most common cases), it depends on the selected ADO Provider.
After the preconfiguration is created, the "PmaAdo > ADO > Database connection parameters" configurator will be set to this value.
Create methods for graphical table displayCreates basic DtiOper interface methods for graphical table display
Create panels for testing table viewingCreates the "TestDbTable" panel for tests and the "ViewerDataTable" panel for table viewing
Enable as Web componentSpecifies whether this object has to be registered as a Web server component
After the preconfiguration is created, the "PmaPanel > Web server > Enable as Web component" configurator will be set to this value.
PmaWeb objectPath in the Pma objects tree to the object PmaWeb, PmaWebFolder or PmaWebLang where the registration is carried out.
Macro expression can be used for input (it is evaluated after the application is launched).
After the preconfiguration is created, the "PmaPanel > Web server > PmaWeb object" configurator will be set to this value.

Pm9.00.24: Created
PROMOTIC 9.0.28 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
- Asynchronous database access - connecting to the database by the PmaAdo object and table usage.
© MICROSYS, spol. s r.o.