Hi Uwe, > - 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 > ... > What is my mistake?
The wizard is only able to append rows, not columns. With the scenario you describe above, it's probably trying to add <rows> new rows to the table, with the first column containing the values you just pasted, instead of adding those values to a newly created <columns+1>st column. You migh consider this a missing feature, not a bug, but: In general, it is not defined in which order a database does return the rows of a table. That is, even if you in the first step copied, say, 100 rows to the table, afterwards OOo does not *know* which row was the first, the second, and so one. When you want to append the additional column, OOo has to ask the server for the 100 rows, again - which the server in theory might deliver in *any* order it finds suitable. So, OOo does not have a chance to recognize that which row in the table to match with which row in your new column, thus, the results of such an append operation might be completely unexpected. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
