| |
| 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();
|
|
| Hits/month |
2,500,000+ |
Downloads (Since May 2000) |
7,393,709 |
| Total Files |
6,023 |
| Forum msgs |
7,670 |
| Articles/FAQs |
70+/900+ |
Top Selling Software at Amazon
|