Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Easiest way to add a new column to table?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00331157
Message ID:
00332198
Vues:
16
Hi Rich.

>I'm actually just changing the name of a column to a new name. Plus, I have to then change the sign of the values in the field once it has been named.

SDT can handle renaming the column. You'll have to change the contents yourself after the update has been done.

>The problem is that the current tables are all free tables at the client site and are not in a DBC. This is my conversion to putting them into a DBC.

SDT will handle that too. When you call Update, it not only checks for differences in physical structure, it also looks to see if the header of the table is different than expected. These differences include FoxPro 2.x structure, free table, or table in a different DBC. SDT will handle all of these cases. For example, using SDT is the only mechanism to add a FoxPro 2.x table to a DBC at a client site without getting the dreaded "This will change the structure of the table. Do you want to continue?" (this is paraphrased) dialog.

Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform