Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Dear Alex:
The SQL command works!!! Thank you so much!
However, I really hope the GUI of Base works as flexible as Calc.
Maybe developers would make it someday.

Regards,
Minhsien0330


2013/5/31, Alexander Thurgood <alex.thurgood@gmail.com>:
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



-- 
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.