Hi Dore,

I have three existing application, which are the collective work of our programer team. The first is called Query (inside it is BtCrit, which I worked on and modifing a little bit again right now), which performs select * from JoinCommand where WhereCommand. It selects all fields from all tables, which are in Query. Then follows Alter Table (inside Query application) to get rid off suffix _a in fields names. Then we run another application XForm, which performs field formatting (involving Lookups tables, etc.) Here I need Output Template. Then we run third application Reporter, which creates different output files (SDF, Comma-delimited, Printed reports, etc.). All these applications are already written and work pretty well. The second XForm requieres all Output template (Output table structure), which we put in predefined place (XFormShells). I was working on creating another Output template based on existing... I've done it already (spent ~ half of hour or even more)...

>Hi again. I saw an earlier response of yours to Erik Moore and I think I finally get it. You want to issue a COPY TO ... SDF without listing the fields in that command. My guess is that some combination of COPY TO EXTENDED and manipulation of the underlying table structure as records in a table will enable you to make a user interface that works better for you than MODIFY STRUCTURE.
>Good Luck.
>
>>Hi Dore,
>>
>>I agree, that there are workarounds, but I still want a Visual convenient tool for this. At least I want to be able resize Builders and Designers.
>>
>>>Hi Nadya,
>>>I don't think that others disagree with you that the MODIFY STRUCTURE implementaion in VFP is inconvenient. I think the consensus is that
>>>order of fields in the base table isn't relevant and that work-a-rounds
>>>such as ALTER TABLE and cursor creations in SELECT - SQL suffice.
>>>-Dore
>>>
>>>>Hi Garrett,
>>>>
>>>>I'm not sure, how can I change field's order, using ALTER TABLE. Anyway, I already passed more than 1/2 way of changing structure manually, so I'll spent another 15 min. to finish it. What I'm saying, that it's inconvenient in its current implementation for this kind of task. Since nobody agrees with me, that it would be better to change, I may do it for myself in a future, when I would have time.
>>>>
>>>>>>Now, when VFP7.0 Revealed, I'm wondering, are there some changes in Builder
>>>>>>sort commands, like, for example, Modify structure? In current state I find
>>>>>>this command very inconvenient, because:
>>>>>>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?
>>>>>
>>>>>Have you checked out the ALTER TABLE command?