General information
Category:
Coding, syntax & commands
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only