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 insert row between two existing rows

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


Joined: 30 Aug 2005
Posts: 3

PostPosted: Sat Oct 01, 2005 11:55 pm    Post subject: how to insert row between two existing rows Reply with quote

hi all,

OO2.0RC1, winxp non-english windows

i use tables | create table in design view created a simple table include

primary key
first name
last name
note

if i want to add a row called 'mobile' between 'last name' and 'note' in the table, how can i do it?
insert row seems only append mobile after note...


thanks
regards,
rg
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Oct 02, 2005 1:02 am    Post subject: Reply with quote

rg,

You can't. Not using the GUI tool anyway. Actually this is a function of the way SQL would handle this. Once a table is made you can DROP a column and you can ALTER a table with ADD column. The ADDed column is always appended to the end of the table.

This isn't really that much of a problem. Say I have your new table

primary key
first name
last name
note
mobile

I want to vew it in a different order. I can just create a query that uses this one table, or a view. And in the query I can rearrange the columns as I like.

HTH

Drew Jensen
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
rg
Newbie
Newbie


Joined: 30 Aug 2005
Posts: 3

PostPosted: Sun Oct 02, 2005 10:32 am    Post subject: Reply with quote

Hi Drew,

thanks for your reply Smile

so, is that mean to put 'mobile' after 'note', use either 'insert row' or directly type the field 'mobile' below 'note' will be the same Question

if the above assumption is correct, the 'insert row' seems redundant...

regards,
rg
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Oct 02, 2005 2:26 pm    Post subject: Reply with quote

yes it does doesn't it.

Drew
_________________
Blog - http://baseanswers.spaces.live.com/
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