<html aria-label="message body"><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">FreeBSD 12.2<div>Filepro 5.7.00.09D4</div><div><br></div><div>I have found a few occurrences of what appeared to be data corruption in a few fields in my database. </div><div><br></div><div>In the fields where this had occurred, the screen with those field values would appear to show an “upper left hand corner line” where there should have otherwise been an ascii letter or number, as the edit type for the field is (6,allup). </div><div><br></div><div><div style="display: block;">http://flantec.com/images/filepro1.png</div></div><div><br></div><div>I have examined the keyfile in a hex editor, and the 6 characters for this field, represented on the far right as “……”, have ascii values as “00” for each character, the NUL character. As you see both above and below the 00’s, every other “blank” character in each field is represented by “20”, the standard space character. No matter if you blank out a field manually, or send a lookup(8)=“ “ type of command, the blank field will always be made of “20” ascii characters. </div><div><br></div><div><div style="display: block;">http://flantec.com/images/filepro2.png</div></div><div style="display: block;"><br></div><div style="display: block;">In addition, this only affects this field in question, without affecting the fields either prior or after, which I would assume rules out any intermittent failing drive. Not to mention, this corruption to the field appears to happen on the original save of the record, and not as the result of any subsequent edit to the record.</div><div style="display: block;"><br></div><div style="display: block;">So, my question is does anyone have any idea what could possibly be happening here, resulting in an ascii “00” character, and even more importantly, how to possibly prevent it? Thank you very much in advance...</div><div><br></div><div><br><div>
<div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);"><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">James Flanagan</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span style="text-decoration: underline;"><a href="http://Flantec.com/">Flantec.com</a></span></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span style="color: rgb(121, 121, 121);">email:<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:James@Flantec.com"><span style="color: rgb(0, 106, 227);">James@Flantec.com</span></a></span></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">mobile:<span class="Apple-tab-span" style="white-space: pre;"> </span>760-458-8498</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">home: <span class="Apple-tab-span" style="white-space: pre;"> </span>219-221-6219</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span style="color: rgb(121, 121, 121);">text:<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:7604588498@txt.att.net"><span style="color: rgb(0, 106, 227);">7604588498@txt.att.net</span></a></span></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">Skype:<span class="Apple-tab-span" style="white-space: pre;"> </span>Flantec</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(0, 106, 227);"><span style="color: rgb(121, 121, 121);">ichat:<span class="Apple-tab-span" style="white-space: pre;"> </span><span style="color: rgb(0, 106, 227);"><a href="mailto:James@Flantec.com">James@Flantec.com</a><span class="Apple-tab-span" style="white-space: pre;"> </span></span></span></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121); min-height: 14px;"><br></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);">home:<span class="Apple-tab-span" style="white-space: pre;"> </span>1901 Cidermill Road</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none; orphans: 2; widows: 2; margin: 0px; font-variant-ligatures: normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal; color: rgb(121, 121, 121);"><span class="Apple-tab-span" style="white-space: pre;"> </span>Michigan City, IN 46360</div><span style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;"><br class="Apple-interchange-newline"></span><span><img alt="PastedGraphic-1.tiff" src="cid:E6A45117-C06D-4883-A671-77F5B7D04E70"></span>
</div>
<br></div></body></html>