Hello
May be I misunderstood something fundamental, but while I can copy the
content of a scalc document into my mysql database, by creating a new
table, it seems impossible to attach new data to this table, from my
scalc document.
In steps:
- I start with a scalc document mark all a colums do copy and
then past in the database window, I have to create a new
table, set a primary key look for the format and voila the
new table is created, so far so good.
- now I add a column in my original scalc document and want
to have that column added as well. So I mark the column, do
copy and paste it in the table new I choose attach data, I
have to select the name of the table to which I want to add
the data (in my case MatIQ.table1 MatIQ is the name of my
mysql database.) Now I get the message of my odbc driver
" duplicate entry '1'for key 1, continue anyway""
I say yes, but nothing happens that is NO new column is
added.
What is my mistake?
Thanks
Uwe Brauer
If this is a bug, not reported of course I send and issue.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
