Board index » delphi » Secondary index

Secondary index

In which way can I insert secondary index in a table Paradox run-time
with Delphi 3?

                                            Thank you, Indy.

 

Re:Secondary index


Quote
On Thu, 10 Dec 1998 20:35:38 +0100, Tommaso <br...@apf.it> wrote:
>In which way can I insert secondary index in a table Paradox run-time
>with Delphi 3?

One way is with the TTable.AddIndex method. For example (assuming the table
already has a primary index):

  Table1.AddIndex('StateCo', 'State;Company', []);

Another way is to execute the SQL statement CREATE INDEX from a TQuery.

  CREATE INDEX StateCo ON "Customer.db" (State, Company)

//////////////////////////////////////////////////////////////////////////
Steve Koterski                 "What is success in this world? I would say
Technical Publications         it consists of four simple things: to live
INPRISE Corporation            a lot, to love a lot, to laugh a lot, and
http://www.inprise.com/delphi  from it all, to learn a lot."
                                                     -- Richard J. Needham

Other Threads