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

Modify Table [SOLVED]

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


Joined: 29 Jul 2010
Posts: 2

PostPosted: Thu Jul 29, 2010 3:32 pm    Post subject: Modify Table [SOLVED] Reply with quote

Hi,

I am trying to alter a table (Tables pane > right click on the table > modify) and rearrange the different fields.

The problem is that I cannot add a field between 2 others. When I do this, the new field is added at the bottom of the fileds list.

Is there any way to add a field between 2 others ?

(I know it's completely irrelevant to have a field before another , but it's just for my table to be clearer when I add records manually.)

Many Thanks
MAx


Last edited by maxou33 on Thu Jul 29, 2010 4:03 pm; edited 1 time in total
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Thu Jul 29, 2010 3:53 pm    Post subject: Reply with quote

MAx:

You asked:

MAx wrote:
Is there any way to add a field between 2 others ?


Please see / read the link below:

http://www.oooforum.org/forum/viewtopic.phtml?t=70021

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post title ( edit button ) if your issue has been fixed / resolved.
Back to top
View user's profile Send private message
maxou33
Newbie
Newbie


Joined: 29 Jul 2010
Posts: 2

PostPosted: Thu Jul 29, 2010 4:02 pm    Post subject: Reply with quote

oh I see

I didn't know i needed to write SQL to do this.
(well i can no longer write SQL queries anyway as I've become a casual user years ago..: ) )

Many thanks for the tip
Back to top
View user's profile Send private message
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