Promotic
WikipediaLinkedInYoutubeTwitterFacebook

CreateIndex - method of the PmaDatabase object

Description:
Creates the index over the column of the database table.
Syntax:
Boolean CreateIndex(String sName, String sField, Boolean bDesc, Boolean bPrima, Boolean bUnique, Boolean bIgnoreNulls, Boolean bRequiered)
Parameters:
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 (the value must be always set up)
Note:

By repeating the method more indexed files can be created.

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

See also:
Example1:
JavaScriptVBScriptSelect and copy to clipboard

var bCreateIndex = oDb.CreateIndex("PK_date", "datecol", 0, 1, 1, 1, 1);
Example2:
See the example in the description of the Create method
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