Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rename table which is part of DBC
Message
 
 
To
28/11/2001 16:02:33
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00585933
Message ID:
00587188
Views:
26
>Hi,
>
>Simply go in project manager and open databases tree then your.dbc tree then tables tree and rightclick on table wich you want to rename and select rename; then modify rule aliases where you used.

Thanks. I used Alexander's suggestion of two simple commands and they work just fine. The only thing, which was my mistake, that we need to specify the correct path in this COPY command. I forgot to do it, so I created these tables in the incorrect place. So, I moved them to the correct place, then re-validate database. My mistake, so I paid...

Not a big deal, though...
>
>
>>>Hi everybody,
>>>
>>>Sorry, if this problem was asked before. How can I rename the table (and the file) for the table, which is part of DBC. I have NextID table, now I want it to be StatID instead.
>>
>>You are in luck...the new table has the same number of characters as the old.
>>
>>I tihnk you can do this, but be sure to back up all files first so you can start over if need be...
>>
>>Open the DBC as a table. Then go to the record that relates to your NextID table. Change the name of the table in the "objectname" property to "StatID". Then, in the "Property" memo field you will see a bunch of unprintable charcters as well as the table file name in there. Change the "NextID" to "StatID". Because the names have the same number of characters, I think the DBC will let you get away with this hack, at least it has worked for me before. If the table names had different lenghts, I think the DBC gets confused and the table record becomes invalid.
>>
>>After that, if it does all work, you will need to go in and change the references to any triggers, etc. you had on the table, but you can do that with the standard table designer screens...
>>
>>Hope this helps!
>>
>>JoeK
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform