Re: Error wiht VB 5 and MySQL

2006-04-25 Thread Daniel da Veiga
On 4/24/06, Gabriel Mahiques [EMAIL PROTECTED] wrote: 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.) Ok, so, I didn't quite understand. Let me see, you can see

Error wiht VB 5 and MySQL

2006-04-24 Thread Gabriel Mahiques
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

Re: Error wiht VB 5 and MySQL

2006-04-24 Thread Daniel da Veiga
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,

Re: Error wiht VB 5 and MySQL

2006-04-24 Thread Gabriel Mahiques
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