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.