Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing the database name.
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00693276
Message ID:
00693325
Vues:
21
>>Hello Group,
>>
>>I have a large database with a lot of tables, views, remote views, and connections. What risk is there in changing the name from CATC to BACC. Seems in the past when I tried that I got messages that table mytable belongs to CATC database.
>>
>
>Each table in the database has back link to DBC stored in it's header. If you rename DBC tables back links would still point to the old name and cause the message you described. To rename DBC properly, open the project, go to Data tab, find DBC, right-click on it and select rename. This way bacl links will be updated also.

Hi Sergey,

On Friday I had a similar problem. I had a table, which belonged to one DBC. I needed to add it to another DBC and preserve captions, comments, etc. (the fields were only 10 chars long fortunately). We had problems with Internet for couple of hours, so I could not ask advice here. After few unsuccessful attempts, I freed the table, added it to the right database and recreated captions and comments manually. Do you know a better way of doing such operation?

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform