OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

how to change column order

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
shri
General User
General User


Joined: 07 Dec 2004
Posts: 25

PostPosted: Sat Apr 23, 2005 8:16 am    Post subject: how to change column order Reply with quote

Hi
I have a table (with about 18 columns in it). Some columns were added later on.
I would like change the order of the columns, so that the related columns are next to each other. (I know for relational queries this does not matter, but for visual inspection I want to see the related columns togther).
I tried to drag the columns to proper places (where I wanted them), but that did not work.
It seems that the only way is to drop the table and recreate it (with the proper order for creating columns).
Is there any easier way?
Thanks
- shri
Back to top
View user's profile Send private message
Lazy-legs
Super User
Super User


Joined: 21 Jul 2004
Posts: 564
Location: Århus, Denmark

PostPosted: Sat Apr 23, 2005 2:17 pm    Post subject: Reply with quote

Here is an idea: create a query or a view. Then you can rearrange columns via simple drag-and-drop.

Kind regards,
Dmitri
_________________
http://code.google.com/p/writertools/
Back to top
View user's profile Send private message Visit poster's website
rnelson
Power User
Power User


Joined: 08 Mar 2005
Posts: 66
Location: Denver

PostPosted: Sat Apr 23, 2005 4:15 pm    Post subject: change column order Reply with quote

Query views are nice, but this product is so infantile that the ability to edit or insert from a query is not yet available.

I've had to copy and past the table definition and data to a new table and reorder the fields before creating. I've been able to sometimes preserve the original table name by deleting the original then copying the copy to the original table name

very inconvenient and quite kludgy solution for a great product

r
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group