Preconfiguration "MySQL server - connecting to the database by the PmaAdo object and table usage."

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 local object menu or after pressing the Insert key after selecting the object) and is included in the group: " / Database access / MySQL server".
This preconfiguration can be created in the object: PmaFolder or PmaRoot.

The PmaAdo object is created including the configured interface for selected database type. The connection string is also preconfigured in the DbConnectionString property in order to allow connection to selected database. This will need to be modified in some cases to meet the requirements for connecting to the database on the target computer..

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..

These configurators can be set before the preconfiguration is created:
The name of created objectName of the object created in the tree of Pma objects. The maximum name length is 30 characters. This is a system name, so it must contain only alphanumeric and must not contain any diacritics, empty string, spaces and the first character must not be a number.
Default: "DbMySQL"
Object scripting languageApplication object scripting language
0 - vbscript
1 - javascript
Database connection stringWhen working with file databases, it is necessary to modify the path to the file or data files folder (dBase) in the created connection string.
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 tree of Pma objects to the object PmaWeb, PmaWebFolder or PmaWebLang where the registration is carried out.
Macro expression can be used for input (it is evaluated after starting the application).
After the preconfiguration is created, the "PmaPanel > Web server > PmaWeb object" configurator will be set to this value.

Pm8.03.24: Created
PROMOTIC 9.0.17 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
- MySQL server - connecting to the database by the PmaAdo object and table usage.
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice