Hi Uwe, > I have encountered the following problems for tables which are > connected to a mysql data base via the odbc driver: > the table is generated and some new fields should be added. > > - when choosing autoformat no field is added
What do you mean by "autoformat"? > - the display is not refreshed I have to leave the table > display another one and return in order to see the new > fields, this is very annoying. I assume you mean the table data view (opened by double-clicking the table) whose columns are in fact not updated when you change the design. Instead of closing and re-opening, you might also choose "rebuild" from the "refresh" drop down icon in the toolbar. You might also submit an RFE requesting automatic updates. I'd consider this a valid, though not-too-high priority, RFE. > - once the field is generated its name can not be changed nor > its format: Bug or feature? What type do you see in "Edit|Database|Connection Type"? "MySQL" or "ODBC"? Should definately be MySQL, *not* ODBC, then editing columns is possible. > - when choosing decimal / or numeric and specifying the > standard format, a column full of zeros is generated. I > have to change the standard format to format 1234,45 in > order to prevent this strange outcome. Hmm, cannot reproduce. IssueZilla might be happy about your more detailed description :) > - the copy and paste of non text columns into scalc documents > suffer from the following all numerical formats (decimal > numeric) end up with the symbol of the euro added. When > data or time stamps are chosen they end up in the calc > document as ###. These problems can be repaired by setting > the format of the columns in the calc document, but this is > inconvenient. Since for the next fresh up the same > behaviour happens. again: Hmm, cannot reproduce. Sample database (result of a "mysqldump" for the table in question, plus .odb file accessing this database) might be useful in IZ .... Thanks & 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]
