Re: OO: 1.1.x: problems with the edit tables

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 -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -