Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rename table which is part of DBC
Message
From
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:
00587181
Views:
21
This message has been marked as a message which has helped to the initial question of the thread.
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.


>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform