CreateIndex - method of object PmDatabase

Creates the index over the column of the database table.
CreateIndex(sName As String, sField As String, bDesc As Boolean, bPrima As Boolean, bUnique As Boolean, bIgnoreNulls As Boolean, bRequiered As Boolean) As Boolean
b = oDb.CreateIndex(sName, sField, bDesc, bPrima, bUnique, bIgnoreNulls, bRequiered)
sName(String) Index name
sField(String) Column name over which the index is defined
bDesc(Boolean) Sort type:
true - from Z to A
false - from A to Z
bPrima(Boolean) Index is defined as the primary key
bUnique(Boolean) Duplicate values are not allowed in the sField column
bIgnoreNulls(Boolean) In the created index the records that have set the Null value, will be excluded.
bRequiered(Boolean) Values <Null> are not allowed in the sField column (a value must always be set up)

By repeating the method more indexed files can be created.

The method is not functional if the Technology configurator is set to Access through ODBC.

See the example in the description of Create method
PROMOTIC 8.3.30 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