Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change field order
Message
From
28/03/2014 09:20:38
 
 
To
26/03/2014 21:53:45
General information
Forum:
Visual FoxPro
Category:
Stonefield
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01597377
Message ID:
01597544
Views:
56
>I'm told by my co-workers that this does not work properly, or reliably, and they have been adding fields to the end of table structures as a workaround.

I just tested it and it works correctly. However, as noted in the documentation, there's one scenario that isn't supported:

"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."

>Is SDT still supported?

Yes.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform