Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integers have oddly changed by 128
Message
From
25/09/2002 22:54:16
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
25/09/2002 10:53:33
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00704018
Message ID:
00704549
Views:
18
>>>
>>>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.

Actually, a 64 byte integer. You can see they take 8 bytes when you add one to a table.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform