Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Examples of MySql database usage

MySql database in the PmTrend object

- When creating the object from Preconfigurations PmTrend - Trend group set the configurator Storage type to: Database MySQL cyclic.
- In a newly created PmTrend object, on the Storage page, set the configurator Storage type to: Database MySQL cyclic.

The trend values can be defined on the Data page or in the ExtTrend of the PmData object.

If the database files do not exist, these will be created on first applicagion launch, when calling the Run method or RunTime method over the PmTrend object. Or automaticaly by checking the Automatic value saving after the launch is enabled configurator on the Trendpage.

MySql database in the PmDatabase object

- When creating the object from Preconfigurations PmDatabase - Database, select: ODBC; Data source.
- In a newly created PmDatabase object, on the Database page, set the configurators: Technology, Database (file, folder, data source), Table (file), etc.

MySql database in the PmAdo object

- When creating the object from Preconfigurations PmAdo - ADO database, select the database type: MySql and in Database connection parameters configurator select: ODBC - Named ODBC source.
- In Database connection parameters it is necessary to modify the name of ODBC source (eventually user and password).
The PmAdois created, containing the DtiOper method on the Methods page. This method represents the basic inteface for working with database tables and can be used, for example, by the Preconfigurations Panel with editable table viewer of data source viewer.
 
The interface uses the ADO technology that can be extended by additional functionality:
Example:
Create new table data with columns nTime (time, primary key, mustn't be NULL), 'flags' (integer, mustn't be NULL) and 'value1' (real number, mustn't be NULL).
pMe.DbExecute "", "CREATE TABLE data (nTime TIMESTAMP PRIMARY KEY, flags INTEGER NOT NULL, value1 FLOAT NOT NULL)", ""
 
See dev.mysql.com/doc/refman/5.6/en/index.html, www.junext.net/mysql/.
Navigation:
 
 
- Examples of MySql database usage
 
 
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice