General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only