The
PmaAdo object is created, containing the
DtiOper method on the "
Methods" tab. 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, must not be NULL), 'flags' (integer, must not be NULL) and 'value1' (real number, must not be NULL).
JavaScriptVBScriptSelect and copy to clipboard
pMe.DbExecute("", "CREATE TABLE data (nTime TIMESTAMP(6), flags NUMBER(8) NOT NULL, value1 NUMBER NOT NULL, CONSTRAINT nTime_pk PRIMARY KEY(nTime))", "");
pMe.DbExecute "", "CREATE TABLE data (nTime TIMESTAMP(6), flags NUMBER(8) NOT NULL, value1 NUMBER NOT NULL, CONSTRAINT nTime_pk PRIMARY KEY(nTime))", ""See
http://ss64.com/ora,
http://download.oracle.com/docs