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

[SOLVED] New field - position in a table

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


Joined: 09 Mar 2007
Posts: 30

PostPosted: Tue Sep 28, 2010 9:41 pm    Post subject: [SOLVED] New field - position in a table Reply with quote

I have an extant table to which I would like to add a new field - in the second position. First field is an ID which serves as the index and I would like the new field to come before all others. It appears that the only place I can add is at the end, below all others. I have tried various ways of moving it from there up the hierarchy but none has worked. I assume I am missing something - could anyone help, please? Smile=
P.S. is there an emoticon for a bearded smiley? That is what the = should be.
_________________
Keith Sayers keiths@apex.net.au


Last edited by Keith Sayers on Thu Sep 30, 2010 2:08 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
Sliderule
Super User
Super User


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

PostPosted: Tue Sep 28, 2010 9:54 pm    Post subject: Reply with quote

  1. [Solved] Changing field order in Table Design mode

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

  2. [solved]How to Insert a new field in design view?

    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
Keith Sayers
General User
General User


Joined: 09 Mar 2007
Posts: 30

PostPosted: Thu Sep 30, 2010 2:06 pm    Post subject: Reply with quote

Well, well - ingenious! This worked :
ALTER TABLE "TableName"
ADD COLUMN "NewName" VARCHAR(40)
BEFORE "Extant Name"

Now that I know how to handle that SQL facility I may use it to solve other problems.

My thanks to everyone.
_________________
Keith Sayers keiths@apex.net.au
Back to top
View user's profile Send private message 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