Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's wrong with VFP 5.0a's math (or is it me)?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00032141
Message ID:
00032285
Vues:
41
>Jeff,
>
>While this sounds onerous and ominous, it *does* also seem like someone has probably supplied the answer!
>
>In your statements below you say:
>
>>But without the program running, if I type variable1 = 0.04998, variable2 = variable1 * 217.18, I get the correct answer.
>>
>>I am unable to reproduce this by creating a new program.
>
>Your previous message stated that the data is actually coming from another data source (SQL Server if I remember).
>It certainly follows in my mind that there is a direct connection between *THAT* particular data and the behaviour observed. It would appear that the 'translation' of the data is consistent BUT not quite as expected.
>I have no idea as to the exact translations performed, but would hope that it is documented somewhere. I'm betting that that is where the answer lies.
>
>good luck,
>Jim N

I think that would be a very good bet. Now that you mention it, I'm reminded of a previous problem I had. I had a remote view of a MS SQL Server table, and when I would enter a certain amount into a field, it would convert to another number. I think I was entering 65.1 and VFP would convert it to 65.09 (or the other way around, I can't remember). Anyway, the problem turned out to be witht he ODBC driver I was using. I was using the drive that installed with the SQL Server Enterprise Manager client. When I switched back to the drive that ships with VFP 5.0a, the problem went away.

Jeff
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform