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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
--
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
