Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Create - method of the PmaDatabase object

Description:
It is used to determine 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.

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.13 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice