Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change field order
Message
De
28/03/2014 09:20:38
 
 
À
26/03/2014 21:53:45
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01597377
Message ID:
01597544
Vues:
57
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform