Adding Secondary Indexes without a Primary Index

Inus van Sandwy

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Adding Secondary Indexes without a Primary Index

Do anyone know how to programatically add a secondary index to a table
without a primary index . The database desktop allow one to do it, but
programming it seems
to be a problem.

Any help will be appreciated !
Inus

Sundial Servic

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Adding Secondary Indexes without a Primary Index

In article <01bc807a$f875dad0$6ce019c4@cdi218> "Inus van Sandwyk" <ivsnd...@clindata.co.za> writes:

Quote

>Do anyone know how to programatically add a secondary index to a table
>without a primary index . The database desktop allow one to do it, but
>programming it seems
>to be a problem.
>Any help will be appreciated !

You can create a secondary index without a primary key, but that index will
not be maintained. In other words, as soon as any change whatever is made to
the table, the index becomes "out of date" and must be rebuilt.

Other Threads

1. paradox7 tables-creating secondary index without primary

2. Create Secondary indexes without Primary?

3. create a Secondary index without a primary?

4. I cant add a secondary primary index

5. Index - Creating new MDX index without previous index to copy

6. How to know if the key violation is in primary or secondary indexes

7. How to get indexed fileds in a secondary index file at run time

8. How I do to create a secondary index to paradox tables without the DataBase DeskTop

9. Do I need a secondary index on a field that is part of a key index

10. Add a secondary index to a database in runtime