Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integers have oddly changed by 128
Message
From
25/09/2002 10:53:33
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
25/09/2002 10:42:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00704018
Message ID:
00704250
Views:
20
>>
>>BTW, we also saw currency fields unexpectedly changing. But those fields changed by trillions. It was asy to spot those errors. :)
>>
>
>It's probably the same thing: since currency are stored as fp numbers, a change in the seventh bit will most likely cause a radical value change (in the exponent, for instance). You could try to check this out with the hexedit tool - and compare values before and after your correction. So, at random places in your database files, bytes are being ored with 10000000. A virus attack? RAM or network problems?

While I basically agree with your analysis, I don't think currency values have an exponent. I understand they are stored as an integer. The value stored as an integer would be the value the user sees, multiplied with 10,000.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform