Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 creating indexes with the TTable create function


Why is it that when I create a table using the TTable component's CreateTable method it creates the fields correctly but does not create the indexes even though I do a NewTable->IndexDefs->Assign(Table ->IndexDefs)?   

    This is the correct way to transfer the index definition to NewTable, however, the IndexDefs property of Table may not be up-to-date so you need to call the Update method of Table's IndexDefs property prior to its assignment to NewTable as shown in this example:

       NewTable->Active = false;
       NewTable->DatabaseName = "DBDEMOS";
       NewTable->TableName = "Temp";
       NewTable->TableType = ttParadox;
       NewTable->FieldDefs->Assign(Table ->FieldDefs);
       NewTable->Table ->IndexDefs->Update();    // Do an update first
       NewTable->IndexDefs->Assign(Table ->IndexDefs);
       NewTable->CreateTable();
    

     



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use