>Hi Naomi.
>
>>We have a table called Client_Product_Lines which has two fields among the other fields:
>>cproduct_line_fk and cproduct_line
>>
>>Recently we wanted to remove one field from that table. Every time we run Update structure, the cProduct_Line field seems to take data from cProduct_Line_fk field.
>
>See the answer to "When I used Update() to update my table structures, the contents of two fields in one table were swapped." in the Frequently Asked Questions topic in the help file (near the end of that topic).
>
>Doug
Do you mean:
After I use the Update method, the data in some of my fields has switched. For example, the data in CountryTaxCode now appears in CountryTaxStatus and vice versa.
SDT doesn't support the following scenario: you have two long field names that have the same first ten characters (such as "CountryTaxCode" and "CountryTaxStatus") and you rearrange the order of the fields so that the one which appeared later in the table now appears before the other. What happens in this case is that VFP changes the name of the field in the DBF file (which is only ten characters long) without SDT's knowledge. As a result, when you use the Update method to update the table's structure, the contents of these two fields will be swapped. Since the order of fields in a table shouldn't be important, avoid doing this.
We're not changing the order of the fields, we're deleting one of the existing fields. I guess behind the scene the order of the fields still will be changed...
If it's not broken, fix it until it is.
My Blog