This if off-the-wall, but try SET DECIMALS TO 4. Might work.
>I have a table with a Float field. When I execute the SQL in FoxPro the cursor contains only 2 decimal points (it seems it is rounded)
>Now, I have tried in Microsoft SQL and this does not happens. It comes as it is with 4 decimal places.
>Is FoxPro rounding when retrieves the data?
>How can I fix this problem?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
