Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Integers have oddly changed by 128
Message
De
25/09/2002 09:32:59
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00704018
Message ID:
00704194
Vues:
20
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform