Issue 12852 - Opening a MySQL data base will not allow edit or new records
Summary: Opening a MySQL data base will not allow edit or new records
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.2
Hardware: PC Other OS
: P1 (highest) Trivial (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-03-30 22:02 UTC by jaynicks
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
batch file to create and populate table. (579 bytes, text/plain)
2003-03-30 22:03 UTC, jaynicks
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jaynicks 2003-03-30 22:02:19 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
=================================
Comment 1 jaynicks 2003-03-30 22:03:25 UTC
Created attachment 5351 [details]
batch file to create and populate table.
Comment 2 Frank Schönheit 2003-03-31 08:33:23 UTC
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
Comment 3 Frank Schönheit 2003-05-20 11:40:56 UTC
closing
Comment 4 hans_werner67 2004-02-02 13:03:16 UTC
change subcomponent to 'none'