Oracle database in the PmAdo object
- In Database connection parameters it is necessray 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 Preconfigurations Panel with editable table viewer of data source
The interface uses the ADO
technology that can be extended by additional functionality:
Create new table data with columns nTime (time, primary key, must not be NULL), 'flags' (integer, must not be NULL) and 'value1' (real number, must not be NULL).
pMe.DbExecute "", "CREATE TABLE data (nTime TIMESTAMP(6), flags NUMBER(8) NOT NULL, value1 NUMBER NOT NULL, CONSTRAINT nTime_pk PRIMARY KEY(nTime))", ""