Promotic

Create - method of the PmaDatabase object

Description:
It is used for specifying the begin of the creation database table mode
Syntax:
Boolean Create()
Note:
Before it's called, the database and the table must be closed (e.g. by the Close method).
This method is not functional if the "Technology" configurator is set to Access through ODBC. In this case to create the table it is necessary to use the MS SQL language and call the Execute method for the command execution.
The method cannot create *.xls MsExcel files; such file can be created by calling the CreateObject method.
See also:
Example:
JavaScriptVBScriptSelect and copy to clipboard

var oDb = pMe.Pm("/Database");
if (oDb.IsOpen())
{
oDb.Close();
}
oDb.Create();
oDb.CreateField("column1", 8, 0);   // 8 = Date
oDb.CreateField("column2", 3, 0);   // 3 = Integer
oDb.CreateField("column3", 6, 0);   // 6 = Single
oDb.CreateField("column4", 10, 100);   // 10 = String
oDb.CreateIndex("column1", "column1", false, true, true, false, true);
oDb.CreateEnd();
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.