Hi E C,
What backend are you using? What's field type, size, e.t.c on backend?
>Table : ItemPrice
>
>Field :
>
>id(I) price(D,4)
>------------------------------
>1 1.2000
>2 2.0030
>3 2.1000
>4 1.5000
>
>
>When I using SQLEXEC('SELECT * FROM itemPrice')
>
>I get the price field with only 3 decimal places eg.
>
>id price
>--------------
>1 1.200
>2 2.003
>3 2.100
>4 1.500
>
>
>How to make the price field have 4 decimal?
>
>TIA.
--sb--