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 <[email protected]>: > 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: [email protected] > 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: [email protected] 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
