Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Decimals
Message
 
 
À
05/03/2003 21:27:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00761918
Message ID:
00762144
Vues:
22
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform