Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MODIFY STRUCTURE - any alternative?
Message
From
15/05/2000 14:36:26
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00369548
Message ID:
00369729
Views:
15
>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?)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform