[libreoffice-users] Re: How to insert a row between current fields?

Le 31/05/13 02:42, minhsien0330 a écrit :

Hi,

> Dear all:
> When editing field names in Design View in Libreoffice Base, I cannot
> insert a new row between current fields.
> If I click the "Insert Rows", Base will add a new row at the end of
> this table, but not the current site.
> Does Base not support insert a new field that just like Calc does?
> Thanks.

No. Base is, well, a database program. Calc is...a spreadsheet, not a
database program. The two are constructed differently, behave
differently and have different code, which is as it should be.

However, I would agree with you that if the user is provided a user
interface which leads the user to believe that he/she can do such a
things as graphically insert a new field definition, then that
functionality should actually work. As you have noticed from your
attempts, it does not. This is one of the older limitations of Base,
that has been around for a very long time.

The solution to your problem is to use a SQL command via the Tools > SQL
menu :

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


If this doesn't work in the version of LibreOffice you are using, then
this is a bug, because with the post above, it worked in OpenOffice.org
back in 2008.


Alex




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted