2006/10/7, KLEIN Stéphane <[EMAIL PROTECTED]>:
Hi,
I use OpenOffice.org Base v2.0.4 on Ubuntu with Mysql v5.
I've connected to mysql database with success. Now, I would like
create a new table. To do it, I've define integer "id" field and
varchar "foo" field . Next, I primary on "id" field with right button
on first table column. When I save my table I've this error :
"""You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ' `foo` VARCHAR, PRIMARY KEY (`id`))' at line 1"""
Why OpenOffice.org Base do this error ? How can I create table in OOo Base ?
I've this in my /var/log/mysql.log
CREATE TABLE `Table1` (`id` VARCHAR,`foo` VARCHAR, PRIMARY KEY (`id`))
Why 'id' is VARCHAR and in OOo UI I've set 'id' on Integer [INT] ?
It's a bug ? I must make a bug report ?
Regards,
Stephane
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
