Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MODIFY STRUCTURE - any alternative?
Message
From
15/05/2000 14:48:37
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00369548
Message ID:
00369737
Views:
17
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform