« Return to Thread: Trouble with decimals when connecting to MySQL natively

Re: Trouble with decimals when connecting to MySQL natively

by Luis Felipe Marzagao/Andamentos :: Rate this Message:

Reply to Author | View in Thread

Thanks a lot for answering. I´ll do the tests and report back.

This page should be updated:

http://forge.mysql.com/wiki/Connector_OpenOffice#Download_MySQL_Connector.2FOpenOffice.org

The download links should point to:

http://extensions.services.openoffice.org/project/mysql_connector

I don´t think I have the credentials to edit it.

Thanks a lot!
Luis Felipe


Frank Schönheit - Sun Microsystems Germany escreveu:

> Hi Luis,
>
>  
>> In one table, I have a decimal column. No matter what I enter in this
>> field, the value always return to 0,00. In my country (pt_BR), the
>> defalut format for money is 0.000,00. So I can't add any amount via
>> Base, because when I jump to the next record, the value returns to 0,00
>> (on the tableview).
>>    
>
> This was a known issue in the Alpha version of the connector, but to my
> best knowledge is fixed in Beta. Please check in the extension manager
> which version you're using. If necessary, upgrade to Beta
> (http://extensions.services.openoffice.org/project/mysql_connector) and
> report back whether the problem persists. If so, please submit an issue,
> and attach the result of a "SHOW CREATE TABLE <table>" statement, so we
> can use the same table structure you're using.
>
> Thanks & Ciao
> Frank
>
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

 « Return to Thread: Trouble with decimals when connecting to MySQL natively