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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement