General information
Category:
Coding, syntax & commands
>>>>How can I create , by program, the back link for a table to mark it as belonging to a database ?
>>>>Is it only possible with the instruction "VALIDATE DATABASES RECOVER" ( But it runs only by the Command Windows) ?
>>>>
>>>>
>>>>thanks
>>>>
>>>>Alessio
>>>
>>>Programmatically, wouldn't the following work?
>>>
>>>Open Database MyDB
>>>Add Table MyTable Name MyLongTableName
>>>
>>>This assumes the table is a free table (not already part of another DBC). Or have I missed the point of your question? You may have to issue a REMOVE TABLE command first.
>>
>>The problem is that I want to rebuild a corrupted file cdx without loosing anything of the table relation in my Database.
>>I found a solution and I think it works :
>>
>>First I do a Copy structure with production of My table "TBL1" to another table named for example "TBL2" then I append from
>>TBL1 all the records to TBL2. This recreate the index.
>>Then I rename TBL1 in TBLX and finally TBL2 in TBL1.
>>Now if I open MyDB TBL1 is still in it with all its relations and integrity referacial , but it missed the BackLink.
>>To solve it I create a Form with a DataEnvironment containing TBL1. When I run it for the first time it gives me a MessageBox
>>asking if I Want to re-create the backLink for the table TBL1.
>>What do you think abaot it ?
>>
>>Alessio
>
>You may suffer from index bloat since you are not deleting the index tags and recreating them from scratch. See Barbara Paltiel's thread on this from Friday or Saturday (Aug 15 or 16). Otherwise, I consider a solution that works to be at least a good solution, if not the best solution.
Thank you for your advice. I'm going to find a better solution.
Alessio
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only