You're welcome

>Thanks Sergey
>I update my ODBC driver
>problem solved.....
>
>
>Are you using the latest ODBC driver?
>
>>In mysql table fields
>>qty numeric(5,0)
>>price numeric(12,5)
>>amount numeric(12,2)
>>
>>bu when I
>>sqlexec(lnHandle,"select * from MysqlTable","tmp")
>>my vfp tmp table always show 4 decimal places
>>how to make it shows decimal places just like MysqlTable ?