Apache OpenOffice (AOO) Bugzilla – Issue 12852
Opening a MySQL data base will not allow edit or new records
Last modified: 2006-05-31 14:29:06 UTC
In Open Office 1.0.2 MySQL tables may be viewed but not edited (even though it has a primary key). Many attempts and variations including the one documented below. After using MySQL (MySQLd version() 4.0.12-max-debug-log and MySQL) to create a table in d.b. myaddr (batch commands below) the create and inserts work fine. MySQL works with the data fine. OO.o displays the data and the table description fine. But the Edit and new record buttons are not enabled. This also happens with a table created through OO.o 'New Table'. attachments: ================================================================================ LoadAnna.bat creates the table (some long lines altered by the OO.o form. so that the >>cmd.sql re-direction is not on the correct line). ================================================================================ @echo off cls echo use myaddr; > cmd.sql : Create table echo drop table if exists annapolis;>>cmd.sql echo create table `annapolis` (`ID` integer auto_increment NOT NULL auto_increment,`name` varchar(50),`phone` varchar(50), PRIMARY KEY (`ID`));>> cmd.sql echo show tables; >>cmd.sql echo load data infile 'f:\\aweb\\mysql\\annap.txt' into table annapolis >>cmd.sql echo fields terminated by '=' (name, phone) ;>> cmd.sql echo quit>> cmd.sql : :Now run MySQL using the command table we just created. mysql -v -u jay <cmd.sql =============================================================================== Sample data for LoadAnna.Bat ================================= 1st Bapt Chrch Annap Cmptr = 1 (410)267-6907 1st Chesapeake Financial Corp = 1 (410)280-2461 1st Chesapeake Mrne Mgmt Corp = 1 (410)263-5011 1st Potomac Mortgage Corp = 301-261-2002 2 Hulls = 1 (410)280-0028 21 Bun Salute = 1 (410)263-2840 22 Continue = 301-261-4322 2nd Natl Fed Svngs Bnk Anne = 1 (410)224-8666 2nd Natl Fed Svngs Bnk Anne = 1 (410)268-6635 3 Centuries Tours Annapoils = 1 (410)263-5401 4 Winds Intrntl Trd Show = 1 (410)349-0820 5 7 9 Shops = 1 (410)224-8689 7 Eleven Stores = 1 (410)757-5955 7 Eleven Stores = 1 (410)267-7329 7 Eleven Stores = 1 (410)269-6627 84 Lumber Co = 1 (410)757-4684 A & B Abstracts Inc = 1 (410)263-0035 A & B Marine Trucking Inc = 1 (410)269-1720 A & B Yachtsmen = 1 (410)263-9073 A & B Yachtsmen = 1 (410)263-9093 =================================
Created attachment 5351 [details] batch file to create and populate table.
Thanks for reporting this - however, this is a known problem which (at least partially) the MySQL drivers have to be sued for :). Please see http://dba.openoffice.org/FAQ/#dataupdate for an explanation. Additionally, there are sevaral discussions about this in the users@dba and dev@dba mailing lists, so I suggest digging the archives for this. Thanks Frank
closing
change subcomponent to 'none'