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