List:General Discussion« Previous MessageNext Message »
From:Gabriel Mahiques Date:April 24 2006 7:57pm
Subject:Re: Error wiht VB 5 and MySQL
View as plain text  
but, when the fields are float type, this error don't happen. When the 
fileds are float the result is the correct (if I have 1.2569 in the 
table, in the application I see "1.2569".)
Daniel da Veiga escribió:
> Check the way your forms deal with the data from the resultset, any
> implicit conversion? Maybe a declaration of type that is casting
> another type for the value returned from the resultset.
>
> Also check this:
> http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html
>
> On 4/24/06, Gabriel Mahiques <mahiques@stripped> wrote:
>   
>> Hi.
>> A Brief description about my problem.
>> We have many applications development in Visual Basic 5. These
>> applications read data from MySQL 4.0 installed on Linux (and odbc
>> 3.51.06). Many fields in our tables are in decimal format.
>> Last weekend we installed MySQL 5 on Linux
>> When we ran the applications they had an error: all data in decimal
>> format return "???????" (for example: if the data must be 1345,68 the
>> form show "????????").
>> Can anybory help me.
>> --
>> Saludos cordiales.
>> ------------------------------------------------------------------------
>> Ing. Gabriel Mahiques
>> Dto. Control de Gestión
>> ELECTROINGENIERA S.A.
>> Telefono: 474 1414
>> Uspallata 1461. Barrio San Martín. CP: X5008HSH
>> Córdoba. República Argentina.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>
>>
>>     
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------
>
>   

-- 
Saludos cordiales.
------------------------------------------------------------------------
Ing. Gabriel Mahiques
Dto. Control de Gestión
ELECTROINGENIERA S.A.
Telefono: 474 1414
Uspallata 1461. Barrio San Martín. CP: X5008HSH
Córdoba. República Argentina.
Thread
Error wiht VB 5 and MySQLGabriel Mahiques24 Apr
  • Re: Error wiht VB 5 and MySQLDaniel da Veiga24 Apr
    • Re: Error wiht VB 5 and MySQLGabriel Mahiques24 Apr
      • Re: Error wiht VB 5 and MySQLDaniel da Veiga25 Apr