Create - method of the PmaDatabase object
Description:
It is used for specifying the begin of the creation database table mode
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();
Dim oDb
Set oDb = pMe.Pm("/Database")
If oDb.IsOpen() Then
oDb.Close
End If
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