Subject dUFLP:FixDBF7 repairing BLOB errors From JBumatay <jedheart@protonmail.com> Date Tue, 29 Aug 2023 16:10:07 -0400 Newsgroups dbase.getting-started Hello, I downloaded the latest dUFLP. Followed the instructions in the FIXDBF7.PRG file notes. Of course, I had a BLOB error to fix. I used the Command line instructions instead of the the posted ones at: https://www.dbase.com/Knowledgebase/faq/ErrorBlobOrMemoFileIsCorrupt.asp There are 4 files: Fixed.dbf which had a Corrupt.txt message. Fortunately, only one BLOB memo field was corrupted. Looks like I had a copy that I had edited that corrupted another copy I had already archived. I had tried to merge them with Append. I use Autoincrement but there was also up to 3 copies of various fields. All of those readable in dBASE except for the 1 corrupted one. I can read the corrupted on in both CDBF Viewer and DBF Viewer 2000 when I cannot open them in dBASE. Been able to do that as a workaround for years. But, there were 2 other files after I ran dUFLP:FIXDBF7.PRG on mycorruptedblob.dbf file: temp.dbf which as mycorruptedblob.dbf file structure; and, Oodml_cur.dbf. That surprised me that I had a record of the proccess in dbf files. Thank you for that. I can read the temp.dbf file in dBASE. I cannot read the Oodml_cur.dbf file in dBASE but I can in DBF Viewer 2000. That is where I could see that my Memo field had 2 versions. One has the html marks and one has plain text. Not sure why. Maybe I edited it after I had made a copy. I usually work with files if I need to look at dbf files I cannot run with dBASE with the mentioned tools. But often they also change them. They always have BLOB errors if I do some processing that I cannot figure out how to do in dBASE. In any case, I am now seeing that if I add some code to my forms that I use, I need to account for the Fixed.dbf, Temp.dbf, Oomdl_cur.dbf and Corrupt.txt so I can repair but also locate the problems. I am not sure how to implement a code procedure to read the Oomdl_cur.dbf using the tools in dBASE. I am in no hurry. Although, I do hope to learn how to use this in code with a button on a form. Thanks for the FixDBF7, Jbumatay