Examples of using the dBase database

dBase database in the PmTrend object

- When creating the object from Preconfiguration "PmTrend - Trend group" set the configurator Storage type to: Database dBase backups.

- In a newly created PmTrend object, on the Storage page, set the configurator Storage type to: Database dBase backups.

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 launch is enabled configurator on the Trendpage.

dBase database in the PmDatabase object

- When creating the object from Preconfiguration "PmDatabase - Database", select: dBase.

- In a newly created PmDatabase object, on the Database page, set the configurators: Technology, Database (file, folder, data source), Table (file), etc.

dBase database in the PmAdo object

- When creating the object from Preconfiguration "PmAdo - ADO database", select the database type: dBase and in Database connection parameters configurator select: DBase - Provider Microsoft orDBase - Provider Jet.4.

- In preconfigured Database connection parameters it is necessary to modify the filename and path to the database files folder.

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 Preconfiguration "Panel with editable table viewer of data source" viewer.

The interface uses the ADO technology that can be extended by additional functionality:

Example1:

Create new table data with columns nTime (time), 'flags' (integer) and 'value1' (real number).

pMe.DbExecute "", "CREATE TABLE data (nTime CHAR, flags NUMERIC, value1 FLOAT)", ""

Example2:

Remove table data

pMe.DbExecute "", "DROP TABLE data", ""

PROMOTIC 8.3.20 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remark Contact responsible person

Navigation:

- PROMOTIC SCADA/HMI system

- Documentation content

- Subsystems

- Database

- dBase

- Data type in dBase