table views problem (MySQL, ODBC, OOo)

table views problem (MySQL, ODBC, OOo)

am 21.08.2005 23:21:34 von L A

I have just installed unixODBC and MyODBC as shown on
http://mail.easysoft.com/pipermail/unixodbc-support/2004-Aug ust/000111.html
so as to link MySQL to OpenOffice.org.

While using OpenOffice's Data Sources, I can create and save a table
in Design View.

The problem is that i cannot edit it in Table View. The error that I get is=
:=20
"This database does not support table views!"=20

I cannot edit a table at all, that is I cannot insert any information
in the table. I also get some strange behaviour when trying to edit
the Table Index.

Using OOo 1.1.3 on a Mandrakelinux 10.1 Official.

__________________
thanks in advance

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: table views problem (MySQL, ODBC, OOo)

am 22.08.2005 00:40:43 von Daniel Kasak

L A wrote:

>I have just installed unixODBC and MyODBC as shown on
>http://mail.easysoft.com/pipermail/unixodbc-support/2004-Au gust/000111.html
>so as to link MySQL to OpenOffice.org.
>
>While using OpenOffice's Data Sources, I can create and save a table
>in Design View.
>
>The problem is that i cannot edit it in Table View. The error that I get is:
>"This database does not support table views!"
>
>I cannot edit a table at all, that is I cannot insert any information
>in the table. I also get some strange behaviour when trying to edit
>the Table Index.
>
>Using OOo 1.1.3 on a Mandrakelinux 10.1 Official.
>
>
OOo is not designed for editing MySQL tables ... particularly version
1.1.3. You are lucky to have gotten as far as you have.

You should use the mysql command-line client, or if you're adventurous,
the mysql-administrator GUI client to alter tables, but pay *close*
attention to the 'alter table' command that it creates before applying
changes ... it does some pretty whacky things.

OOo is targetting an embedded Java database in the upcoming 2.0 (
currently 1.9.xx ), and OOo's table editing abilities are really only
good for this embedded database.

You can try with the 1.9.xx series and see if you get any further, but
don't expect to be editing table designs from 1.1.x.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: table views problem (MySQL, ODBC, OOo)

am 27.08.2005 14:28:04 von Alex Thurgood

Le lundi 22 août 2005 à 08:40 +1000, Daniel Kasak a écrit :

Hi Daniel,

> OOo is not designed for editing MySQL tables ... particularly version
> 1.1.3. You are lucky to have gotten as far as you have.
>

That is not entirely true : you can edit table designs and create new
tables via the OpenOffice.org GUI. The real difficulty of using OOo with
MySQL is finding a combination of MyODBC version and OOo version that
will live together happily. Unfortunately, with Linux being as
mutlivalent as it is, each distribution tends to have its own version of
the MyODBC libraries, and this causes numerous headaches, from not being
able to edit data once a table has been created, to incorrect field type
interpretation.


> You should use the mysql command-line client, or if you're adventurous,
> the mysql-administrator GUI client to alter tables, but pay *close*
> attention to the 'alter table' command that it creates before applying
> changes ... it does some pretty whacky things.
>

I do agree, however, that the OP would be better off creating his tables
using the CLI, or some other interface, e.g. mysql-cc or
mysql-administrator, as you pointed out (there are many other graphical
interfaces of course, PHPMyAdmin, Webmin mysql module, etc), that will
do as equally good a job.

One thing that new users do need to be aware of is the requirement for
any table used in OOo to have a primary key in order for the table to be
editable. If none of the fields have been defined as primary key, there
is no way you can edit your data from within OOo (except perhaps via the
API and macro scripting).

Alex


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org