Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Examples of using Microsoft Access database

Microsoft Access database in the PmTrend object

- When creating the object from Preconfiguration "PmTrend - Trend group" the Storage type configurator set to: Database Access backups (obsolete) or Database Access cyclic.
- In a newly created PmTrend object, on the Storage page, the Storage type configurator set to: Database Access backups (obsolete) or Database Access 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, then these will be created on first applicagion launch, when calling the Run method or RunTime method over the PmTrend object. Or automatically by checking the Automatic saving after launch is enabled configurator on the Trendpage.

Microsoft Access database in the PmDatabase object

- When creating the object from Preconfiguration "PmDatabase - Database", select: Microsoft Access.
- In a newly created PmDatabase object, on the Database page, set the configurators: Technology, Database (file, folder, data source), Table (file), etc.

Microsoft Access database in the PmAdo object

- When creating the object from Preconfiguration "PmAdo - ADO database", select the database type: Microsoft Access and in Database connection parameters configurator select: Access - Provider Microsoft or Acces - Provider Jet.4.
- In preconfigured Database connection parameters it is necessary to modify the filename and path to the database file.
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:
Example:
Creates 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).
VBScriptSelect and copy to clipboard

pMe.DbExecute "", "CREATE TABLE data (nTime DATETIME PRIMARY KEY NOT NULL, flags SMALLINT NOT NULL, value1 FLOAT NOT NULL)", ""
 
See http://msdn.microsoft.com/en-us/library/ff841695.aspx.
See also:
- List of statements and stored procedures of the MS SQL Server database language
- Preconfiguration "PmAdo - ADO database"
- Preconfiguration "PmTrend - Trend group"
PROMOTIC 9.0.0 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
Navigation:
 
- PROMOTIC SCADA/HMI system
- Documentation content
- Subsystems
- Database
- Access
 
- Data types in Microsoft Access
- Examples of using Microsoft Access database
 
 
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice