MySQL database in the PmAdo object
- In Database connection parameters it is necessary to modify the name of ODBC source (eventually user and password).
is 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"
The interface uses the ADO
technology that can be extended by additional functionality:
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 TIMESTAMP PRIMARY KEY, flags INTEGER NOT NULL, value1 FLOAT NOT NULL)", ""