Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Utility for corrupted field values
Message
De
18/10/1999 10:37:09
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Titre:
Utility for corrupted field values
Divers
Thread ID:
00277660
Message ID:
00277660
Vues:
54
I am looking for a utility that can detect/fix corrupted field values. I just picked up SDT over the weekend and cruised through the manual rather quickly. While it looks like a very useful tool, it appears that it is not going to help me with data corruption at the field level. Here's what I need specifically:

I have tables which have valid headers, but browsing the fields will display what I'll call "black bar" corruption. These data fields are storing ascii values which are not within the range of printable characters, and are displayed as black bar control characters. It is easy enough to find these in character fields by simply parsing the fields and looking for invalid ascii values, but numerics/dates are a different thing. VFP apparently doesn't have any problem going ahead and evaluating a field with this type of corruption in numerics. If, for example, I have a value of 1.56#8 (# representing corrupted value visible in the field), then VFP will simply evaluate the numeric to 1.56. Likewise a stored value of #3.45 will evaluate to zero (0). This type of corruption is only detectable in VFP (as far as I can tell) while browsing since it doesn't seem to recognize the bad data while processing commands against the field value.

Does anyone know if FoxFix helps in this regard? A description of the product on Hallogram states that it will work with "field data value corruptions" but I'm not sure if this refers to the type of corruption I'm seeing. Any other tips/help would be greatly appreciated!
Répondre
Fil
Voir

Click here to load this message in the networking platform