>VFP 6
>
>I am in a table and I want to change the position of a column. I have to drag the columns and drop it at the new desired place.
>
>The thing is that there are many columns in that table ant that process takes some time to accomplish (too long for what needs to be done).
>
>Is there a way to do that faster?
>
>If not possible where can I post this as a suggestion for a SP or a future version of VFP? I looked in the menu for a document or some place where I could post that as a request and have'nt found anything.
If you're working with a free table, a SQL-SELECT with the fields ordered the way you want is quick.
If you're working with a table in a DBC, I don't think there's simple command to accomplish the change.
In that case, I think the following would work. If you're not using relational links to other tables, copy the table to a new DBC. DROP the table from the current DBC. COPY TO ... DATABASE Original.
If you are using relational links to other tables, you could do that and then recreate with ALTER TABLE commands.
Depending where you are, it might just be simpler to make the change visually if it's a one shot deal.
Jay
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only