>This if off-the-wall, but try SET DECIMALS TO 4. Might work.
>
Another approach would be to add 000000000000.0000 to the number to force a format on the field, or use NTOM() to force a currency field.
>>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?