Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MODIFY STRUCTURE - any alternative?
Message
De
15/05/2000 14:36:26
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvanie, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00369548
Message ID:
00369729
Vues:
14
>1) I can not move several fields at once
>2) If I have lots of fields (like 100, for example), it's very hard to use Mover to move them, say, from 50 to 10.

>My question is: do you know about more User-friendly interface for modifing structure? In free tables?

Here's a trick: List stru to (textfile)
Open the textfile in Excel (set Excel columns along output columns)
Create a single column with name/type/size [ex, D4=A4&" "&B4&"("&C4&")" ]
Select the range and paste special, (values)
Now arrange the fields however you want them using cut/paste
Select the range and copy
Open word, and paste special (unformatted text)
Replace all carriage returns (^p) with comma-space
Copy that, and paste it into a VFP create table command.
If applicable, index the new table (very fast on empty tables)
Select the new table, and append from the original

It might sound like a lot of steps, but it's pretty quick once you know what you're doing. i've saved myself hours of work usig this technique (it only takes about 5 minutes per table from "list stru" to "append from") It does require some work, but it's FREE (everyone has Excel&Word, right?)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform