Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integers have oddly changed by 128
Message
From
25/09/2002 09:33:01
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00704018
Message ID:
00704195
Views:
18
David -

I checked, and they aren't *supposed* to be using anything else (Other than VFP7) to access the data in our system.

Why would this matter? Do these other products have a history of corrupting VFP tables? We thought it was too odd that seemingly random integer fields keep changing by EXACTLY 128.

BTW, we also saw currency fields unexpectedly changing. But those fields changed by trillions. It was asy to spot those errors. :)

- George

>George,
>
>Are they accessing these tables from some other program? Like Excel or Access or dBase?
>
>>We have a sticky problem at one of our client's sites. They are experiencing some odd behavior in several tables. It seems that integer fields are mysteriously changing values by 128 (that's right, 2^7).
>>
>>Has anyone ever seen this happen to them? The clients are getting upset, and rightfully so. So far, we have been able to correct the data by looking at backup tapes. But this is a band-aid over the true problem. We are seeing this happen in multiple tables and with different fields.
>>
>>Oh, one more thing: we tried putting update triggers on the data, but the triggers haven't fired. The records affected were added 2 years ago or so. They hadn't changed at all until a few weeks ago. Our system is set up in such a way that these records really never change.
Previous
Reply
Map
View

Click here to load this message in the networking platform