Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MODIFY STRUCTURE - any alternative?
Message
 
 
À
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:
00369740
Vues:
17
Hi Michael,

Sounds interesting... I may try to use this technique in a future.
Thanks.

>>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?)
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform