Gott ist groß wie geht es dir On Wed, Jan 19, 2011 at 3:36 AM, der.hans <plug-anwendun...@lufthans.com>wrote:
> moin moin, > > working on a document and running into a problem where I can't put > anything after a table on a page. Insert <blah> just puts whatever in the > last row of the table. > > I think there is not a page break in place, but am not sure. Just added a > manual page break and didn't see any special characters with view special > chars turned on. > > Is there a way to see page breaks? How do I regain ability to type after a > table aside from copying and pasting it above itself with a line break > already in place below the new location? > > I can access my tables with OOo, but I can't update or insert any data - why? There are three possible reasons (counting the frequent ones only :): - OOo requires a table (or, more specifically, the data in a row set) to contain a primary key or a a unique index in order to allow data manipulation. Alternatively, it suffices if the driver supports bookmarks (like some ODBC drivers or the internal dBase implementation do). The reason for this is that this is the only secure way to ensure that the changes you do affect the proper record (in case of updates), resp. that you, later on, can work with your newly inserted record. - You are using a spreadsheet, a text (CSV/TXT), or an address data source. All of these are not yet writable. It's not a bug, it's a missing feature. - OOo asks the database (in reality its the databases driver) for the privileges (if any) the current user has for the table you want to access. If the driver doesn't report that you have INSERT/UPDATE permissions, then the respective functionality is disabled in OOo. There are various drivers out there (for various databases, most often reported is MySQL) which handle the permissions improperly, and return wrong or too few privileges. Please try the latest possible driver for your database. > ciao, > > der.hans > -- > # http://www.LuftHans.com/ http://www.LuftHans.com/Classes/ > # ABLEconf - 2011Apr02 - CfP 2010Jan22 - Free Software for Free Enterprise > # "The only thing that interferes with my learning is my education." > # -- Albert Einstein > > Reference: http://wiki.services.openoffice.org/wiki/FAQ_%28Base%29 -- (503) 754-4452 (623) 688-3392 http://www.obnosis.com
_______________________________________________ PLUG-applications mailing list PLUG-applications@lists.PLUG.phoenix.az.us http://lists.plug.phoenix.az.us/cgi-bin/mailman/listinfo/plug-applications Reminder: All replies will go back to this mailing list. If you wish to send a reply to a specific person, please use the reply function and change the "To:" address to that person before sending.