Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Decimals
Message
 
 
To
05/03/2003 21:27:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00761918
Message ID:
00762144
Views:
23
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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform