Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Create - method of object PmDatabase

Description:
It serves to determine the begin of the creation database table mode
Syntax:
Create As Boolean
Calling:
oDb.Create
Note:

Before it's called, the database and the table must be closed (e.g. by the Close method).

The method is not functional if the Technology configurator is set to Access through ODBC. To create the table in this case it is necessary to use the MSSQL language and 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:
If oDb.IsOpen Then
  oDb.Close
End If
oDb.Create
oDb.CreateField "column1", pmcDbFldDate, 0
oDb.CreateField "column2", pmcDbFldInteger, 0
oDb.CreateField "column3", pmcDbFldSingle,0
oDb.CreateField "column4", pmcDbFldText, 100
oDb.CreateIndex "column1", "column1", false, true, true, false, true
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice