Promotic
WikipediaLinkedInYoutubeTwitterFacebook

CreateIndex - method of object PmDatabase

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

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.

Example:
See the example in the description of Create method
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice