Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Easiest way to add a new column to table?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00331157
Message ID:
00332198
Views:
14
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform