Creating and index on a numeric/integer field

[1HuntnMan]

Researching and can't seem to find how to create an index on a integer field.  See the snipet below:

 Clients.Open;
     {Add the primary index}
     Clients.AddIndex('CUSTID','CUSTNO',[ixPrimary, ixUnique]);
     {Add a secondary indexes}
     Clients.AddIndex('CUSTNAME','CUSTOMER',[ixCaseInsensitive]);
==>     Clients.AddIndex('CNTKIDNO','CNTKID',[ixInteger]);  // Error here on ixInteger!!!!
     Clients.AddIndex('CITYSTCTRY','CITYTOWN+STATEPROVINCE+COUNTRY',[ixCaseInsensitive]);
     Clients.AddIndex('TYPECUST','CUSTTYPE',[ixCaseInsensitive]);
     Clients.Close;

Trying to find all the ix's that can be used Adding Indexes:
    ixPrimary, ixUnique, ixCaseInsensitive and what else.  How would you create an index on an integer field?

[dsiders]

Researching and can't seem to find how to create an index on a integer field.  See the snipet below:

 Clients.Open;
     {Add the primary index}
     Clients.AddIndex('CUSTID','CUSTNO',[ixPrimary, ixUnique]);
     {Add a secondary indexes}
     Clients.AddIndex('CUSTNAME','CUSTOMER',[ixCaseInsensitive]);
==>     Clients.AddIndex('CNTKIDNO','CNTKID',[ixInteger]);  // Error here on ixInteger!!!!
     Clients.AddIndex('CITYSTCTRY','CITYTOWN+STATEPROVINCE+COUNTRY',[ixCaseInsensitive]);
     Clients.AddIndex('TYPECUST','CUSTTYPE',[ixCaseInsensitive]);
     Clients.Close;

Trying to find all the ix's that can be used Adding Indexes:
    ixPrimary, ixUnique, ixCaseInsensitive and what else.  How would you create an index on an integer field?

Valid index options are: https://dsiders.gitlab.io/lazdocsnext/fcl/db/tindexoptions.html.

You should not need anything other than the name for the index and the name of the field:

Code: Pascal  [Select][+][-]

1. Clients.AddIndex('CNTKIDNO', 'CNTKID', []);

It already knows the type for the underlying field.

[1HuntnMan]

Tks DSiders, that was too easy...

[1HuntnMan]

How do you label a subject SOLVED?  I see this throughout the system on questions that were SOLVED.  Do you just add the word SOLVED to the Subject?

[Zvoni]

How do you label a subject SOLVED?  I see this throughout the system on questions that were SOLVED.  Do you just add the word SOLVED to the Subject?

"Modify" your first post, and edit the Subject-Line with "[SOLVED] ....."