Trouble with decimals when connecting to MySQL natively

[Luis Felipe Marzagao/Andamentos]

Hello:

I'm using OOo Base 3.1 and MySQL via native connector. Everything,
including relationships, seems to be working just fine.

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

I can insert values with no problem via mysql client ot phpMyAdmin.

Is it a bug in the connector?

Tks a lot
Luis Felipe

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

[Frank Schoenheit, Sun Microsystems Germany]

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

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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

[Mechtilde Stehmann-2]

Hello Luis Felipe,

Luis Felipe Marzagao schrieb:

> Hello:
>
> I'm using OOo Base 3.1 and MySQL via native connector. Everything,
> including relationships, seems to be working just fine.
>
> 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).

Do you get the latest Version of the mysql connector?

I know this from a version before using form in table view.

But in the latest version it is fixed.

Otherwise give me a hint to reproduce it.

Kind regards

Mechtilde


--
Dipl. Ing. Mechtilde Stehmann
## http://de.openoffice.org
## Ansprechpartnerin für die deutschsprachige QA
## Freie Office-Suite für Linux, Mac, Windows, Solaris
## Meine Seite http://www.mechtilde.de
## PGP encryption welcome! Key-ID: 0x53B3892B


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

[Luis Felipe Marzagao/Andamentos]

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

[Luis Felipe Marzagao/Andamentos]

Ok, problem solved by installing the latest beta version of the connector.

Thanks a lot.

Mechtilde escreveu:

> Hello Luis Felipe,
>
> Luis Felipe Marzagao schrieb:
>  
>> Hello:
>>
>> I'm using OOo Base 3.1 and MySQL via native connector. Everything,
>> including relationships, seems to be working just fine.
>>
>> 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).
>>    
>
> Do you get the latest Version of the mysql connector?
>
> I know this from a version before using form in table view.
>
> But in the latest version it is fixed.
>
> Otherwise give me a hint to reproduce it.
>
> Kind regards
>
> Mechtilde
>
>
>  

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

[Frank Schoenheit, Sun Microsystems Germany]

Hi Luis,

> This page should be updated:
>
> http://forge.mysql.com/wiki/Connector_OpenOffice#Download_MySQL_Connector.2FOpenOffice.org

Uhm, well, that's indeed way outdated. Unfortunately, the MySQL side of
the project team is completely on vacation currently. I'll see if I can
get this sorted out, for the moment I just removed the alpha version of
the driver from the download location.

Thanks & Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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