Hi
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 ?