Did you try to browse SPT cursor with SET RESOURCE OFF? Did you make sure that you've the latest SQL Server ODBC driver? What's VFP version/SP you're using? What's Sql Server Version?

>In SQL server, the field is defined as numeric, 5,2. When I list the structure of the resulting cursor, this field appears to be numeric 7,2.
>
>Other field, having 3 decimals in sql server (numeric 7,3), displays only 2 decimals in the browse while the focus is outside the field, when i place the cursor over the field, it displays all 3 decimals, but the lastone is not significant (always=0) and by listing the cursor structure it reports to be numeric 9,3 (not 7,3 as in sql).
>
>
>>How this field is defined in Sql Server (data type, precision, scale)? What field type/size do you get in a cursor (LIST STRU)?
>>
>>>I've a value of 23.5 on a field on a table in sql server. I'm sure it's 23.5 because that's the value shown by the query analizer when I query the table.
>>>
>>>When I retrieve this field using Sql PT, it seems that only 23.00 is returned; If I check the value of the field on the debug window or if I make a calculation involving the field, it appears to be 23.0; however, when I browse the resulting cursor, the field shows 23.5 when the field hasn't the focus and 23.0 when the focus goes to the field.
>>>
>>>Now:
>>>1. How can I make sure that I get 23.5 when I run a query?
>>>2. How is it possible that Browse shows a different value depending on the field that has the focus?
>>>
>>>TIA.