Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement